For the Vancouver area there are several parks that I would recommend depending on what area you want to be in. I would not recommend Dogwood RV Park; it has degraded to quite a scummy run down place with lots of live ins and is very noisy with the highway upgrade. Fort Langley Camping, Burnaby Cariboo RV Park, Capilano RV Park, and Eaglewind RV Park are all full service parks with decent room even for large rigs. Capilano RV Park is closest to downtown Vancouver although it won't be the quietest place out of these. Further out near Chilliwack is Bridal Falls Camperland Resort which is our favorite local park, although it is likely too far out for sight seeing in the city.
If you can name some of your desired features I can certainly narrow it down for you.