We stayed at the Fairmont Waterfront before our Alaskan cruise. The price is a bit high, but the location was great, the room was nice, and it was convent. The rooftop pool would be fun if your into swimming, the roof top garden with the beehives was a great little diversion, and the free sauna in the gym locker rooms was a treat. It's right across the street from the port, with under the hotel access to shopping and the port luggage drop off if I remember correctly. This is the "Disney" hotel. I would also not hesitate to stay at the Pan Pacific.
We went out to Granville Island. It's like a European market with food vendors everywhere inside the main market. From fresh produce to pre-made potpies. Around the main market are lots of artisan shops. We only had a few hours since we fly in the day before the cruise. We also did Fly Over Canada. It's a "Soarin'" like experience except themed to Canada. It's right next to the port. It was fun, if a bit pricey.
Overall we liked Vancouver and can't wait to go back and try some of the other things on our list that we didn't have time for.