I did some rough math about a few months ago, and I'm spending roughly the same on housing+transportation in Vancouver, than I would be in a couple smaller cities in BC.
Ultimately my situation isn't everyone's, but staying in the city made sense for me.