Over the past 20 years I’ve moved close to one million people and I think I’ve had a problem with less than a half a dozen drunk/drugged up people. The cabin crew have had more but they dealt with. I can even remember the name of the last miscreant. I’ve had more problems with luggage issues and those who think it’s OK to stand up during a landing, so as wiggly says, a sense of proportion is required. The most challenging and more frequently occurring for me are medical emergencies, too many of which are own goals.
PM