While I believe knife hands have their place in a leaders toolbox, expecting people to do their jobs, keeping a clear view of the big picture, and again, hammering the living shit out of the big time fuck ups goes a long way to keeping this kind of behavior from becoming a problem.
We do not have the drug problem of the 70s and 80s; a positive whiz quiz is a genuinely rare thing in the commands I've had the privilege to be a part of.
What we are doing on the drug front is working; hiring the right people and treating them like adults with adult consequences for bad behavior. It goes a long way.
I made it clear to the guys in my shop, when I had one, that I could not tolerate three things: liars, thieves, and someone working on my plane when they weren't fit for duty. Anyone caught doing those would have my full recommendation to be dealt with as harshly as the Skipper could. I never had any instances with any of my big three. I was lucky to have shit hot sailors, a solid Chief who knew what was important and what was not, and no haziness on my expectations.
The day to day standards I expected my Chief to take care of, and I offered course corrections and guidance on the exceedingly rare occasions where I didn't think they were being met.
On the few dets I've had the privilege to lead, the first thing I mentioned in any det brief/last minute liberty mini-quarters/conversations prior to heading out with the gents, was behavioral expectations. Taking a det to NV, it was absolutely clear to all hands that if you broke the one rule, that while legal in the state, was against the UCMJ, I would not hesitate to take your ass to mast faster than you can blink.
Regardless of how I personally feel on the rights/wrongs of prostitution and whether or not two people should be allowed to enter into a consensual agreement to exchange money for sex, I was prepared to enforce the UCMJ to its fullest extent if it was broken.
I haven't had any of the kinds of issues on any of my dets, and being trusted with the chance to go on the road with 20 or more people and a plane, and make mistakes and learn from them while knocking out missions was one of the greatest privileges I've had in my JO tour.