Pinnacle Centre, Waterclub, Harbour Square, The Soho (I think it is called that...not the Soho met, but the Soho off queen by HMV), 500 QQW, 550 QQW - the immediate ones that come to mind, speaking as a condo owner who grew up downtown, raised relatives downtown, and been to many of these condos.
HVE has 5 buildings. Not all experience the same issues. If you are on a higher floor, you may be far away from the ground-level ruckus. I've bumped into escorts, drug dealers, drug dealers arrested by cops, domestic abusers, more prostitutes, and lowlifes, at Cityplace, where I live. It hasn't affected living conditions because it's mostly far away and taken care of quickly. What it does affect and takes its toll, is on the maintenance. HVE's maintenance fees are 10-20% higher than its peers.