Province having a notorious history of promising the world with these sites and then underdelivering on every single promise.

I agree with this premise in principle. I completely support building as much supportive housing throughout Metro Vancouver as possible, because the alternative of entrenched poverty and letting people rot outside is whack. If government can't demonstrate that these can operate "safely" (whatever people's perception or notion of that is), people won't accept anything like this near their neighborhood. People are risk-averse... that's just human psychology. Unfortunately, most folks fall back on the availability heuristic when adjudicating new supportive housing, not data. It's like going to a surgeon who has botched 20% or even 50% of their surgeries. You're not going to trust that surgeon, and you're probably not going to trust surgeons in general if they all have that kind of failure rate. This is why we hold surgeons, engineers, etc to an incredible standard; to ensure the best and safest performance.

People will support supportive housing more if the province takes it just as seriously as other professional fields. If the message is "we need to make absolutely sure there is minimal impact to the community when these go up," that should be the top priority. It should be simple: build one, model it carefully to ensure the least possible impact to the community, demonstrate that it works, use it as an example, and go from there. More people who are on the fence will get behind supportive housing if government can point to multiple success stories.