In some ways, it's funny that in our hyper-medicated age, that a stimulant and a heavy painkiller are still unspeakably taboo. I mean, every graduate school and Ivy League college in our country is awash with powerful stimulants (Adderall). It wouldn't surprise me if a properly controlled/dosed drug with coca extract in it could be more effective than amphetamines for attention issues. I never want to touch heroin, but with the abuse of prescription painkillers, criminalizing usage of one drug (and thus funding criminal networks) seems like a worse and worse strategy.
Largely like today, then. E.g. the largest gateway to heroin use is prescription opioids (which are far more expensive to buy on the black market than it is to buy equivalent doses of heroin from your friendly neighbourhood dealer; and in some countries heroin too is provided on prescription - e.g. in the UK, in addition to occasionally being made available to addicts, it is used as legitimate pain relief for post operative pain though I believe only for inpatient use)
Optimistic - people in mainstream society realise cannabis is not destroying society and slowly come to appreciate that alcohol is not the only drug, and that drugs (and drug users) aren't the devil. The edifice comes tumbling down and we start looking at drug policy (and our massive drug-related budget) in terms of harm reduction.
Pessimistic - the largest group of drug users is brought into the fold of the mainstream. The idea of 'hard' and 'soft' drugs is reinforced and users of anything other than cannabis and alcohol are pushed even further into the category of 'other'. Drug-war resources used against cannabis are diverted into continuing to make everything worse for everyone when it comes to all other drugs. Central and South America and West Africa continue to get torn apart by cartels feeding off Europe and North America's insatiable appetite for cocaine. Other parts of the world that have the raw materials for other drugs (sassafras, poppies) go the same way (if they haven't already). NPS with unknown health profiles continue to be churned out and consumed by the kiloton.
Unfortunately I think the pessimists probably have the right of this one for the next several years at least.