There are simple, expensive answers: highly diligent social workers focusing on homelessness outreach + massive affordable housing construction that crunches housing prices. Regulate the substances but have them available to addicts, and make sure fentanyl is out of the supply chain, and make selling drugs outside the regulated system a felony.
We’re just not willing to pay the bills.