Rafa, I'd suggest that popular travel destinations such as Vancouver are less likely to be whee one finds a deal on anything, as "location" costs are higher. There are other places in Canada where even more competitive aircraft rental prices would be found, though getting yourself there for a few days would not be worth it for the savings.
While on holiday in Iceland years ago, when I was told the rental cost for a 172, I just held my breath, and paid - it was not a "deal" location. I enjoyed every minute of the rental.
You will probably find the cost to rent in the BC lower mainland pleasing to what you may be used to in Europe.