We are staying at Pan Pacific. The hotel is on the expensive side but is right at the pier. I hear it is magnificant. We plan on going a couple of days early because we hear Vancouver is a wonderful city.
If you have access to Entertainment books, you may call them next month - they are in the process of negotiating the prices which would make it affordable.
I hear the Renassiance Hotel by Marriott is also very nice.
Directly across the street from the pier and the Pan Pacific, is the Fairmont Waterfront Centre Hotel. A little less pricey than the Pan Pacific, but also very nice.
We've stayed at, and enjoyed both.