Street safety from gangs and drug traffickers may be better, but property crime is up, and my friends bitch non-stop about used needles, and having to share public space with aggressive homeless people.
Also, 'All the homeless people moving to Vancouver' is a problem, but only a part of it. Most of the non-locals are from small dying towns in the BC interior. They aren't really suited, financially, to dealing with the social problems[1] that result - yet Vancouver would rather close its eyes, and pretend that they don't exist.
Even so, if we sent everyone who isn't originally from Vancouver back to the towns they came from, there would still be a catastrophe of homelessness, overdose deaths, etc.
[1] Yes, it would be much cheaper to provide housing for homeless persons, within their communities, instead of in the most expensive city in Canada. Sadly, nobody in Victoria seems to be keen on fixing this, on a province-wide level. The Liberals didn't care, and the NDP care, but aren't doing anything.