I believe airlines worldwide should adopt a new procedure for handling drunks on board aircraft.
We've clearly seen the arguments put forth relating to immense operating costs the airline incurs by diverting, offloading the pax etc, not to discount delays to other pax and the consequences of this...
So, what I suggest they enforce is the good ol' use of 'Negative Psychology'
If the b#stards want to get nailed and are a nuisance to cabin crew/passengers, the cabin crew should prepare 'the final blow' - an extremely potent alcoholic beverage that'll turn out their lights, so to speak. Then, once passed out, handcuff them to their seats (don't want any irregular convulsions now, do we) place a paper bag over their heads, serves as a chunder-catcher (holes for the eyes of female offenders - if they're pretty (ducks)) and finally record their 'hour of power' on video, a momento for their award-winning stage act. This way, the aircraft hasn't diverted, the remaining pax will meet their flight connections, and costs are maintained to the originally planned budget....minus a few bottles of liquer, of course
Asta la vista, baby !