We stayed at the Fairmont Harborside in Vancouver for five days. The corner rooms have a great view of the straight with the cruise ship terminal directly below you.
Vancouver is a beautiful city with the wilderness just minutes away in every direction. I have never seen the urban and the rural in such close proximity. Vancouver downtown is very walkable and the locals seem to walk a lot. Shopping of every kind is available as are restaurants for every budget and taste. We particularly enjoyed the Caravan for good Middle Eastern fare and the freshest falafel around. Salmon fishing in the fall is good, but not cheap.
Quick Tips:
Visit Victoria while you are here, but a day or two there is more than enough.
Best Way To Get Around:
You really do not need a car here, between the public trasportation, cabs, and your feet, you will be fine unless you plan to drive up to Whistler.