Just make sure your My Way benefit choice is set for upgrade and not points or internet. Otherwise, you may be disappointed as the hotel may not (and in many instances will NOT) give you an upgrade.
I have gotten terrific upgrades on awards, including several suites, as a Diamond.