We have reservations at the Days Inn in Vancouver - relatively expensive (what isn't during "cruise season"?) but very close to Canada Place. I searched the internet and got quite a list. I'd make reservations ASAP, however, because all the motels fill up fast this time of year!
Look at the Renaissance Hotel - if you go to Seacruisechat.com they have links for Vancouver and they have a great list of all the web sites for hotels and stuff. It's a great site. Anyway the Renaissance has some very good internet rates. Don't know if you have AAA or an AARP (don't be offended please I am only 42 and have one through my husband). But using Seacruisechat site is a great way to find out all kinds of info. The trolley is a good way to get around and see the sights. When are you sailing? We are sailing in June on Radiance.
Have a great trip.