The Waterfront has the Bay view whereas Hotel Vancouver is in city center and has the traditonal hotel overtones..
You could book through a website like
www.perfectescapes.com or a Virtuoso TA that can offer a room upgrade if available.. or call ahead to the hotel/reservations and identify a source that is offering upgrades and see if they'll offer that up for you..