Socially I'm pretty liberal but the idea of providing free hard drugs to addicts is really hard to accept intuitively, despite a lot of evidence that it works best at a macro level.

It's also not a clean win. Open a safe injection site and crime and public disobedience goes up in the immediate community. So maybe society is better off, but your neighborhood is substantially worse off. Or you visit the emergency room with a serious but deemed non-life threatening condition and wait 6 hours because all the EMTs are coming in with fentanyl overdoses. These are hard problems that are charged with emotion. You can strongly disagree with prohibitionists, but it's not fair to entirely discount their viewpoint