I've been kidding around a little in this thread. Why can't people go on vacation and have a good time without getting sloppy drunk to the point of being hungover, the next morning? I certainly do... When I'm in Cozumel or Key Largo, just soaking up the beauty, being relaxed, laughing and talking with friends, stellar diving... How is getting stinking drunk going to improve on that, especially if it means that I may end up missing a day of diving because of my lack of self control?
Maybe if a person can't refrain from getting sloppy-arsed drunk to the point of being hungover and unfit to dive, then maybe scuba is really not the sport for them in the first place. Scuba diving is fun, but it also calls for self discipline, attention to detail, and situational awareness, and it is not without the element of risk, the potential for emergencies, and situations where people may be relying on you for their very life.
What part of that is compatible with getting rip-snorting drunk? I honestly don't understand it. I'm no saint, certainly. I've had a few dives when I've been hungover. Fortunately, I learned from them and haven't repeated that behavior. Especially as I've progressed as a diver and matured a little, besides.
Anyway... For whatever it's worth...