Speaking of exit row drunks:
I was on a flight from ORD-AMS 6 years ago with my partner and our 3 kids (aged at time time 6-9 years old). We were 2 rows behind the exit row where 2 middle aged 'gentlemen' were having a little party. The FA kept bringing them handfulls of airline booze bottles, and soon a 20 something from a few rows up was sitting in the flight attendant seat opposite them.
They were obnoxiously loud all night but the FA kept serving them anyway. After another hour or so, the 20-something was friggin' LAP DANCING on them and there was up-the-skirt groping going on. I swear I saw the chick's hoo-hah...and I'm not kidding. The FA ignored it all and if my kids hadn't been sound asleep I would have freaked. As it was I didn't want to raise a stink although looking back I should have.
About two hours before landing, the FA brought the men a paper bag (about lunch bag sized)...they opened it and it was FULL of airline booze bottles. I had seen money change hands before that and clearly this was what it was for. Yep, in the exit row, and the life of myself and my children depended on not only them, but the F/A's making sure that able bodied people sat in those seats. And here the F/A was taking a bribe for a sack full of booze after these two were already trashed. I got the impression these guys were frequent flyers on the route and the F/A knew them, and so they were 'excused' from proper behaviour.
For me personally, I find that drinking any alcohol in flight makes my feet swell up to the size of an elephants. I'm sure it's partly the long flights themselves, but a glass of wine with dinner and I can barely put my shoes back on...and my feet HURT. So I just avoid it. Although I did have a nice First Class from MSP-BOI where I had three wines and must say it was the shortest flight ever...it made sitting next to the professional Amway salesgirl much more tolerable LOL.