I lived in the Vancouver area for seven years. I would rather slit both my wrists with the bunt end of a spoon than venture into "downtown" Vancouver again.
If I had to be stuck in the Lower Mainland for the rest of my life, Ladner is nice - kind of redneck bedroom community, I did my student teaching there. Port Moody is nice - I lived there for a year. I quit an awesome job just to get the hell out of Vancouver (I taught at a highschool that had a 20' Viking head in the front yard (In Burnaby onn Kensington, just off Hastings) . But I am not a city boy at heart.
The highway up to Whistler is gorgeous to drive.
The old Highway #1 (Fraser Canyon) is fun and twisty. When you get to the sharp corner under the traintracks, where all the skid marks sail into the concrete retaining wall - slow down. It gets really boring around Merritt.
I never did the Capilano Suspension Bridge. Supposed to be neat.
Vancouver Aquarium was kinda cool.
Science World is neat.
The Art Gallery is neat (but means going downtown). Pop's truck got broken into when we were there last.
The Pink Floyd laser light show is fantastic if they're playing it while you're there. It's at the Planetarium.
If you or your significant other like shopping, MetroTown in Burnaby has more stores than you can shake a stick at.
There is an Autocross at Pitt Meadows airport this Saturday.
The Canadian Nationals are there as well, August 9-10-11.
If you're willing to travel inland at all, there are far, far more things to see than just what Vancouver has to offer. Vancouver is not representative of the rest of the Province, despite what all the Vancouver folk want to believe (for example, I do not even ~own~ an umbrella up here in the Okanagan Valley).