So enabling an addict *is* a serious concern and SIS are a type of enabling and will result in more addicts delay facing their problems. The question is how to balance the lives saves by preventing overdose vs. the lives destroyed by keeping the addict comfortable with their addiction. It is delusional to pretend this trade off does not exist.
Don't the sites have counseling support ready if they want to quit? What's the quit rate vs the general population? And the death rate? etc.
We don't have the time to delve into the stats and all the literature here, but as MH eluded in the OP, the people in government should and decisions should all be based on evidence based on what outcomes are desired and not knee-jerk emotion.
The thing with Doug Ford is he's not anything near an academic, he doesn't know anything about the scientific process or research & evidence so things will get canned based on emotion and ideology.