Vancouver has plenty of subsidised housing and it's not exactly working out of them. I'm not sure how things operate Houston but I think their crisis is less severe than Canadian cities and West Coast American cities. It could also be that their homelessness is less linked to substance abuse than it is here.
Meanwhile, our downtowns can't afford more trials and errors. The situation is getting really dramatic and at this pace, some cities risk ending up with streets fully abandoned by normal people like Hastings. The Drop-in-Centre is unfair to all of the population of the East Village, Bridgeland, Chinatown and the surroundings. I know the Drop-In Centre center has been here for a while, before the E&V revitalisation, but it's greatly affecting the quality of life of 50K/100K people (not just the people living in the area but also shopping, working, transiting). Are there benefits to having the Drop-In Centre located downtown? Absolutely, it makes essential services more accessible to people in need. But should the needs and safety of 100,000 others also be part of the conversation? In my opinion, yes and it has not been the case at all, even though the Drop-In Centre is financed by the taxes of these 100.000.
I'm a EV resident, pay a significant amount of taxes and never had a say in the story.