The airport is on the coast, surrounded by rivers, so if you take off on 26 or land on 08 then there’s only islands to see. The city is north so it’s not on the flight path the other way either.
I have the city pack and am happy with it. In terms of flying it does add the city seaplane base and maybe a couple of other seaplane bases. If you’re going to fly around Vancouver and enjoy the spectacular scenery you’ll be needing a seaplane really.
Given the amount of cloud and rain that Vancouver gets, you’ll probably need to be flying low to see anything anyway. 
One downside is awful performance in the Vancouver area, as bad as London or maybe even worse. It’s pretty bad even without addons IIRC so something for asobo to look at.