I have seen food sent home with kids only to have the parents sell it for drugs or alcohol.

In other words, do you spend $X creating a well known brand that pulls customers in without much additional marketing effort/expense, or do you spend that same $X on direct customer acquisition.In industries where customers are potentially repeat customers for life (fast food, alcohol, cigarettes, automobiles), spending that money on brand building is cheaper than spending that money on acquiring the same customers over and over -- that's why these industries put a ridiculous percentage of their profits back into building their brand.In real estate, the "customers" are the sellers -- they generate the income, even if not directly.

Alcohol is expensive and damages your body / brain. 

have a physical or mental disability that substantially limits one or more major life activities—including, but not limited to, hearing, mobility and visual impairments; chronic alcoholism (but only if it is being addressed through a recovery program); mental illness; mental retardation; being HIV-positive, having AIDS or AIDS-Related Complex

There are different levels of crazy who cannot take care of themselves, criminals who earn sporadic low income from violent crimes and reselling drugs and fake drugs and tainted drugs, those who's personalities will never let them hold a job for very long, the low IQ who cannot be expected to earn very much from their efforts, the workshy lifelong generational loafers, those down on their luck at the moment and the hardcore alcoholics and drug addicts (plus probably more types).Since they are not a monolith, a monolith solution will not solve the problem. 

You may be able to put limits on the total number of humans allowed in the unit, credit scores above X for each adult, no rude people, people who smell like alcohol at 10AM, smokers, leather-wearers, vegans, etc.  

Many people with dui's spend their rent money on alcohol-I would not take that chance. 

People who have this addiction are more likely to gravitate toward other addictive substances too, like drugs and alcohol.

I had a roommate who was an Alcoholic, used girl-friend as previous landlord references, and of course, eventually could not pay rent.  

But from my research, you can not disqualify someone for drugs or alcohol felonies because it is considered a "mental health disorder" You can always find another reason not to rent that doesn't have anything to do with that. :)