I'd imagine that if you are single you'd want to stay in Vancouver, and that if you have a family you might want to consider moving away. Vancouver is a great place to be single. Heck, looks like I'm in the minority by saying "Vancouver is great fullstop". Go and live in some of the places I've lived and you'll realize what side of the bread your butter is on.
With a DB pension I'd probably wait until retirement before moving away.