This is very important post. Let's see what Torah says and implies about alcohol.
YLT Gn 9:20 And Noah remaineth a man of the ground, and planteth a vineyard,
YLT Gn 9:21 and drinketh of the wine, and is drunken, and uncovereth himself in the midst of the tent.
YLT Gn 9:22 And Ham, father of Canaan, seeth the nakedness of his father, and declareth to his two brethren without.
YLT Gn 9:23 And Shem taketh--Japheth also--the garment, and they place on the shoulder of them both, and go backward, and cover the nakedness of their father; and their faces are backward, and their father's nakedness they have not seen.
YLT Gn 9:24 . And Noah awaketh from his wine, and knoweth that which his young son hath done to him,
YLT Gn 9:25 and saith: 'Cursed is Canaan, Servant of servants he is to his brethren.'
YLT Gn 9:26 And he saith: 'Blessed of Jehovah my God is Shem, And Canaan is servant to him.
YLT Gn 9:27 God doth give beauty to Japheth, And he dwelleth in tents of Shem, And Canaan is servant to him.'
As you can see, the first example is Noah himself in Genesis. He cursed his son because he got drunk. This teaches that alcohol is evil.
YLT Lv 10:8 And Jehovah speaketh unto Aaron, saying,
YLT Lv 10:9 'Wine and strong drink thou dost not drink, thou, and thy sons with thee, in your going in unto the tent of meeting, and ye die not--a statute age-during to your generations;
YLT Lv 10:10 so as to make a separation between the holy and the common, and between the unclean and the pure;
YLT Lv 10:11 and to teach the sons of Israel all the statutes which Jehovah hath spoken unto them by the hand of Moses.'
As you can see, Torah provides very clear explanation of why alcohol is bad. Particularly when you are at work/studying Torah as sons of Aaron were. Alcohol distorts and clouds judgement and make you forget right from wrong. Never work or study/teach Torah when you are drunk, as your judgement will be affected no matter how little alcohol you have consumed. However, there was wine on the Table of Shewbread(Exodus 37:16) so it is unclear if Priests drank any wine inside the Tent. Most likely not, and it was for ceremonial purposes.
YLT Dt 21:18 'When a man hath a son apostatizing and rebellious--he is not hearkening to the voice of his father, and to the voice of his mother, and they have chastised him, and he doth not hearken unto them--
YLT Dt 21:19 then laid hold on him have his father and his mother, and they have brought him out unto the elders of his city, and unto the gate of his place,
YLT Dt 21:20 and have said unto the elders of his city, Our son--this one--is apostatizing and rebellious; he is not hearkening to our voice--a glutton and drunkard;
YLT Dt 21:21 and all the men of his city have stoned him with stones, and he hath died, and thou hast put away the evil out of thy midst, and all Israel do hear and fear.
As you can see, intentional drunkenness is punishable by death. Alcoholics, basically, who drink all day long and refuse to do anything.
However, Torah understands that alcohol is a NECESSARY evil and it is impossible to eradicate it. This is why Torah does not prohibit it and even requires it for the offerings. I.e Exodus 29:40, Leviticus 23:13, Numbers 15:5, e.t.c.
Abstinence from alcohol is considered a "mizvah" (commandment) and there is a special oath for that in Numnbers 6:1-21
YLT Num 6:1 And Jehovah speaketh unto Moses, saying,
YLT Num 6:2 'Speak unto the sons of Israel, and thou hast said unto them, When a man or woman doeth singularly, by vowing a vow of a Nazarite, to be separate to Jehovah;
YLT Num 6:3 from wine and strong drink he doth keep separate; vinegar of wine, and vinegar of strong drink he doth not drink, and any juice of grapes he doth not drink, and grapes moist or dry he doth not eat;
YLT Num 6:4 all days of his separation, of anything which is made of the wine-vine, from kernels even unto husk, he doth not eat.
As you can see, even grapes and juice of grapes has alcohol in it and it affects judgement. This is why a Nazarite was prohibited from eating them. Nazarite during his oath was basically considered a holy person on the level of the Priest I would say.
Please note that organic drugs such as Marijuana, Opium Poppy, e.t.c do not affect judgement as alcohol does, which is why there is absolutely no prohibition in the Torah of the organic drugs, and they are even called food in Genesis 1:29 (Marijuana and Opium Poppy are both seed-bearing herbs).
This is why it is better to smoke couple of joints then to drink couple of beers.
My absolute advice based on the above cited verses is to stay away from alcohol if you can (save it for mourning and celebrations). If you must drink, use organic drugs as a substitute because they do not damage your health as alcohol does, particularly your heart.