AFAIK, the Drug use=automatic DQ is pretty much standard policy amongst LE agencies, but some are far more strict about it than others.
As someone who has smoked a bit of weed in my youth, and recently made it through the application process* for the GCSO let me give you a little bit of...