I'm not as frequent a traveller as many of you, but almost every time when staying I get an upgrade at Marriotts. This has included many suites (at least 6 different hotels). In fact, I get upgraded far more often than not.

In response to the original question, when I am checking in, I simply ask (with a polite smile), 'are there any upgrades available?'