We Vancouverites are spoiled. I just finished an 18 month stint in the Bay Area. One of the biggest inconveniences was the driving time (especially with traffic) to get to the mountains.
In Seattle now and it's a great compromise. Similar wages to the Bay Area but similar geography and outdoor access as Vancouver. And even with the exchange rate housing is cheaper than Vancouver.
I spent a summer in Seattle and did more hiking, kayaking, and biking than I did in the year prior. It's an amazing place to work if you like the outdoors.
In SF, house prices and rent are pretty close. In Vancouver they are disconnected. Equivalent rent can be about half or lower of what the mortgage would cost. Even though the average house is about $4 million now.
The bigger problem is the relatively low wage.
And on top of that everything is more expensive in Canada.
Seattle is definitely the economic sweet spot, and I would live there if it wasn't for the weather and the companies I can work for.
The trick is to work for a Valley firm, making Valley wages, and telecommuting; SAP is the only local shop that pays a decent wage.