I don't see why we have to separate the two. It sounds like Vancouver faces both increasingly high rent and abnormally low salary for tech jobs (although I recognize that we might not expect Silicon Valley level pay).
Alternatively, SF/the US have extremely better salaries for tech jobs. I don't think this is a problem unique to Canada (but presumably its much worse because of easier access to visas).
The brain drain is slow but inevitable.