I don't live there, but I wish I did. I've made a point of visiting the city once every year, however. It's a cleaner, healthier city than the Los Angeles where I live, and for someone whose ancestors came from Hong Kong and Guangzhou, it's also culturally more familiar than L.A. is, really.
Vancouver is known for its scenery, and indeed, they've got something to brag about (especially SW Marine Drive around the UBC area, towards Locarno Beach). But what Vancouver is also becoming known for is that it's a great *diner's* town...probably the best in Canada and even among the best in North America. The Asian cuisine (especially in Richmond) needs no introduction, but the Western cuisine is great too...especially in the Robson district in downtown near Stanley Park.
Overall, a great place to visit...and I imagine, a great place to live. The next Winter Olympics will be hosted there.