What I do know from having rented to thousands of tenants for a twenty year career is probably 90+% of all trouble is with folks who drink and/or do drugs. I am also a recovering alcoholic and former drug user and understand the insanity of those who use.
I would never advocate for the destruction of lives legalizing any more drugs would do and the harm it would cause to others who do not partake in drugs or alcohol suffer as a consequence.
Consider, one who needs to escape, even a small part of reality for any reason has problems, sobriety is great.
There's no good evidence the drug criminalization significantly reduces use - but it does lead to harms and destruction of its own, by putting inflated profits in the hands of violent gangs and cartels.