I had gotten some sort of room upgrade at the Fairmont Tremblant before. Still on the smallish side. airoli is correct in that I didn't think the room (or lobby) was anything special. The only plus for the Fairmont is that internet is free even if you're a peon level member in their program.
I haven't stayed at the Westin Tremblant, though. I also have no idea how they treat SPG Golds but if you're collecting SPG points, it's a no-brainer.