Hi,
Opus hotel has that super noise bar called 100 Nights located next to the lobby, no fun if u stay on the weekend. Yaletown is nice for dinner, but really got nothing to see

Loden Hotel has nice rooms, but u will pay a arm and a leg for parking or breakfast. In coal harbour is not much to see either

St. Regis Hotel is the real deal, I stayed there ones, offering guest free full breakfast, FIJI water, internet and not to forget they are the first hotel who offers guest worldwide long distance calls.
My room looked like, it has been rented out for the first time.
They spent big bucks in that little boutique hotel.

But that's just my opinion.

Have fun in Vancouver
Hotel guru