Perhaps I am being too simplistic, but I look at the "war on drugs" like I look at "war on gun violence". In both cases, the tool is not the issue. The issue is what the user does with the tool. Use a gun to commit a crime like robbery or homicide, get charged for the crime. Take a dump on the sidewalk or operate a motor vehicle while impaired, get charged with a crime. And not misdemeanors. Make them felonies and back things up with tough sentences.
No revolving door for DUI. Do it once is ten years, forfeit vehicle, and lifetime driving ban. Twice is same as ten but twenty years. No parole. No extenuating circumstances. Kill someone while DUI and you get life in prison with no possibility of parole. Yes, some people will spend more time in prison due to a one-time mistake, but the deterrent on so many others will make it useful. Right now, there is no deterrent for abhorrent behavior. I am aware of more than one person with more DUI convictions than fingers. And they still drink and drive because there is no fear of consequences. In an area where it is easier to Uber to/from a bar than to find a parking spot near the bar.
Never going to happen, but I can dream.