The support is pretty good in Vancouver, but there's two big compounding problems.

1 - drugs, which is a massive complication modifier

2 - capacity, which is stressed a LOT by other areas of the country. For example, other provinces have a policy of buying one-way bus tickets to Vancouver for any homeless person who asks (or is slyly convinced to leave). Vancouver can't do anything to stop it, for good reason - freedom of movement within the country is a guaranteed legal right.