It sounds like the primary benefit is reduced ODs for the drug addicts. Does it do anything to benefit productive members of society? Do libraries go back to to being libraries? Do parks once again serve as a place to relax and recreate with family or friends? Does it clean the sidewalk and make them disability-accessible again? Does it stop the property crimes that are committed to buy drugs?
It's an absurd level of misdirected empathy to redirect such massive parts of the society's collective effort to benefit a few people who had some amount of agency in ruining their own lives.