Drunk on a 'plane?
I must have achieved that hundreds of times. Then again - once drunk I tend to fall into blissfull sleep so I don't bother anyone.
Chill out Ten West - pax are supposed to actually enjoy flying not be restrained and treated like Guantanamo inmates. If you want to refrain from alcohol that's up to you but don't force your uncivilized practices on the rest of us.
With regard passengers drinking and becoming abusive or such. Simple. Ban 'em. Any costs - charge 'em.