Andy McV WOW did you luck out! I stayed free on points last December, and asked politely for a chance of an upgrade, but the hotel was full to capacity. Here's what we got:
But I was staying for free & thrilled with that alone, so no worries! Just wanted to share so that people don't assume as an SPG member you automatically get upgrades all the time.