Just spend a 4 nights stay at the Wall 1 month ago. Was given a nice corner suite on the 33rd floor. Great views. The floor to ceiling windows gives very spectaclular views.
The Bayshore is quite nice now after the renovation, you almost feel you are in Stanley Park.
For the view and the center location the Sh. Wall is the best. The Bayshore is like a city resort because of the location. Both of them are good choices.
Also agree that nothing beats the Fairmont YVR, certainly one of the best airport hotel in the world.