Thanks to Gordon Price's tip, I have been enjoying Google Earth's 3d downtown Vancouver for a bit. It is really quite neat to be able to have 3d so easily accessible.
Now if only Street View would hurry up. Google intends to release it rather soon, and I have seen the Google StreetView car around Yaletown last November. Perhaps, the wait will be quite short.