My main question, is it worth investing in Vancouver or should I be searching for alternative options out of province?

The rental market is typically around the 1% mark or better however does vary significantly given your location in the province.

Many provinces have a standard lease agreement for free. 

This is not a Landlord friendly province.  

It's been a long time since I lived in la belle province and I was younger and not terrible interested in real estate at that time, but there are some differences in Québec.

But for now, I was hoping for some feedback on specific relevant numbers for Canada.Obviously it varies by province and sometimes things aren't a percentage of the Purchase price or anything, they are just static fixed numbers.This newer website looks interesting, a spin off of ratehub.cahttp://www.closingcosts.ca/It lets you calculate rough (very rough) closing costs (Rough cost of lawyer and appraisal) and provides listings for Lawyers and appraisers in your area.

I cannot speak for all provinces in Canada, but in most, you use a solicitor/lawyer, preferably one who specialises in Real Estate.

Then you could take out a HELOC on your mortgage-free home and invest in out-of-province real estate.

Ted now resides in Cambodia where he splits his time between Phnom Pen and Kep, a province in Southern Cambodia.

I know the province is heavily oil & gas related to economy.