Lets not forget that in the US not only opioids get legalized, but they were given to people as a substitute for aspirins. And then retired without mercy. Did you get addicted? Well, you are on your own now, go get some fentanyl under a bridge.
I live in Spain. Alcohol is not tighty regulated here, and is cheap if we compare with nordic countries. But we, overall, have a culture of knowing how to drink, low proof drinks and in low quantities. The worst drinkers here are tourists from northern countries that binge on high grade alcohol because it is cheap. I had never seen someone chugging a liter of beer like it is water, or do that thing with a can of beer where you force the whole can, or that other thing with the funnel and a tube, like you were in a hurry to get drunk. You just drink a beer whenever you want, at slow pace. Spain, overall, consumes a lot of alcohol, but the consumption is so spread among the population that you rarely see adults drunk.
Our neighbor in the south, Morocco, allows for marihuana consumption and selling, and they have way less problems with it than any european country. But they have alcohol tightly forbidden, and it is a big problem there.
I went to Finland, and there were ships going from Finland to Estonia, carrying people just to buy cheaper alcohol there. They went back to Helsinki with shopping bags full of vodka. Makes you wonder how does it look Tallin in drinking statistics. I bet something similar is going on between Sweden and Denmark or Germany, whatever trip is shorter and cheaper.
The point is that a culture of taking drugs needs time to develop.
Yes, the swedes take the ferry to Denmark and the danes take the car over the border to Germany.
There has also been a movement to change the culture of drinking in Denmark, and the consumption has generally been going down, although it still remains high among youth. This also goes to show that there are many complex factors at play and that legal status alone cannot explain consumption patterns.
I do believe that prohibition makes it a lot harder to influence the culture around consumption compared to a legalized and regulated market.