As a Gold this year I've been upgraded to a standard suite, a junior suite, a corner room ("the second largest room in the hotel"), and executive floor level. Around 80% of the time that I ask I get a meaningful upgrade. There was only one time where I was upgraded without asking.

I don't always ask but I am usually quite polite but convincing when I do. Anyone with sales background shouldn't have too hard of a time