In my city subReddit I advocated for something that sounds similar; yes housing even for addicts who will shoot up in their new place. Got downvoted. Also people bitter that rent is unaffordable for them too and said no one is entitled to free or reduced rent, since they don't get that themselves. though kind of my point housing should be a human right produced by society to everyone without judgement.
I think there is a misguided paternalistic moral-crusading factor in the states that holds back things like housing first, harm reduction strategies & treatment.