What are the chances there is a repeat of the opioid crisis and in 10-15 years there is an investigation into what went wrong?
It's possible Oregon regrets this for some reason I can't imagine, but a repeat of the opioid crisis isn't a realistic outcome.
https://amp.theguardian.com/commentisfree/2022/jan/03/us-dru...
There are always companies that will try to make bank in an emerging market, but the details are different than an entrenched company using their power like in the opioid crisis.
But there is certainly risk that it creates a new class of problems. But, people are doing clandestine treatment with psilocybes currently, so it seems unlikely that legalization will find new classes of issues or a higher incidence rate of issues vs relatively-uninformed clandestine use. If there is a concerning issue, we'd expect that we've already seen it, but perhaps underestimated it.
But even if there were no such thing as tolerance, psychedelics aren't pleasant in the day-in-day-out way that a beer after work can be, or that I imagine an opioid would be. They require far too much emotional work. It's typical to take a moderate mushroom dose, and then spend a month or two "integrating" the experience (i.e., figuring out what the heck all those insights mean).
The rise in software and hardware innovations that came out of the SF counter culture included Steve Jobs and Apple. He did quite a bit of acid.