I went to uni for six years and then was a phd student for five years, so I've been drunk plenty of times yeah. It was fun in some ways when I was young and reckless, sure, but nowadays I really don't like it. You lose control, you lose judgment, I you can become emotional (for better or worse) and sometimes you even black out or get memory loss. In hindsight it really isn't worth the trouble.
However, having a little bit of a tasty alcoholic drink is not the same thing as getting drunk, imo. Having just a glass of wine or one or two beers in good company or even in a setting with strangers, can be really nice and even helpful. You can become a bit more "yourself", some barriers and filters are thinned out or getting cracks in them, so that you might feel more comfortable socially.
That really makes it sound like a drug, and you know why? Because it is. Alcohol is terribly harmful. However, the social aspect + the amazing taste of many nice drinks, wines and beers out there, makes it worth it for me in small amounts these days. I love craft beer - me and my spouse love trying new fancy things like smoothie beers, deep stouts, super fresh IPAs etc etc, and it's a big thing in my country in recent years. Every tiny town has at least one local craft brewery, I kid you not. And my town has several bars who know their craft beer well - not just "one large beer on tap pls". Unfortunately non-alcoholic variants just don't taste as good, as rich. This interest is not at all about being drunk however, so I suppose I strayed a little bit from your topic :)