I understand this more than most. The solution that fits best with my experience and ideology is probably a combination of a few things. Just to caveat, this is a thought experiment and while a lot has been done, there is so much friction it is absurd.

I would like to see heroin decriminalized with specific designated zones (cities/towns) which fully supply and allow heroin use. If you are caught with heroin outside of a zone you must pay a fine. If you can't pay you are offered rehab or transportation to the administration zone.

Zones provide free narcotics and needles, ect and have adjacent treatment and medical facilities. This experiment has been run and was somewhat successful.

The thought process in my above statement is that broke heroin users can not interact with society. If a user wants to simply do heroin, there can be a designated development/town that allows it. If a user is outside of the zone, they must have the money to pay a fine (stay well) or they need to go to rehab or a place that allows drugs.

That way, normal people can interact and many users can function in society. If they can not they will be supplied with drugs outside of society until they regain financial independence or make the decision to enter treatment.

However, since this is impossible, I do not expect a legit solution to ever be implemented and thus am not sure where I land. So I would support efforts that compromise in a similar way to my above solution, but really not worth thinking much about as the gov (in US) has not even legally recognized recreational marijuana.