When I was young, active LDS and naive about the world, I'd look down at my peers who drank telling myself that they needed alcohol as a crutch to have fun, while I, an obedient LDS lad, didn't need a crutch to have fun.
Well, now that I'm on the other side, I can say definitively that drinking IS fun. Sitting around, at a bar, around a campsite, or whatever drinking, shooting the breeze, etc. is fun, more fun than without alcohol. Alcohol does tend to loosen inhibitions and facilitate a more enjoyable and spontaneous interaction among people. I now have a number of stories (and fond memories) of good and strange (but good strange) times where alcohol has been involved. Having to choose between good clean Mormon and sober 'fun' and alcohol aided 'fun,' I'll take the latter every time.
Personally, I don't like to get drunk. I'll tend to drink to the point where I feel like I'm losing control, and then I'll stop. I do now and then get drunk, but I don't like feeling out of control and I definitely don't like hangovers.
I am a purely social drinker. I rarely drink alone. I tend to prefer beer to spirits--in fact, I don't like most spirits straight (tequila straight, for example, is just horrible and I'm not a big whiskey or bourbon fan) but prefer mixed drinks. Wine is ok, but I can live without it. In many cases, I'd just as prefer to have a Diet Coke than an alcoholic drink.
p.s. I'm not trying to bash anything LDS here. I'm just reflecting on my personal experience here.