And not everyone who works in Vancouver lives in the city of Vancouver either. There are 10 or so other cities within commuting distance.

A fair comparison would compare areas outside of SF with areas outside of Vancouver. There are obviously some outliers like Oakland, but on average you would expect to pay 50%-100% more in rent in the Bay Area than in the Vancouver area.

There is a lot of data available online that you can find very easily. Zillow for example, regarding rent for a one bedroom:

SF average rent: $4,440 USD [1] vs. Vancouver average rent: $2,500USD [2]

Mountain view average rent: $3,395USD [3] vs Burnaby average rent: $1,989USD [4]

Union City average rent: $2400USD [5] vs Surrey average rent: $1689USD [6]

[1] https://www.zillow.com/rental-manager/market-trends/san-fran...

[2] https://www.zillow.com/rental-manager/market-trends/vancouve...

[3] https://www.zillow.com/rental-manager/market-trends/mountain...

[4] https://www.zillow.com/rental-manager/market-trends/burnaby-...

[5] https://www.zillow.com/rental-manager/market-trends/union-ci...

[6] https://www.zillow.com/rental-manager/market-trends/surrey-b...