I think it depends on where you stay and when. I'm diamond, my wife is gold. She has gotten a number of upgrades in hotels that I haven't been upgraded in and vice versa depending on time of year, availability, etc. For me, I think it's interesting to compare our battle field experiences of upgrades within the house and argue over who got the better upgrades or who, presumably, got shafted.
Some 'upgrades' I'm not really sure are upgrades. She had booked an executive floor room recently at the Harrisburg, PA Hilton. Checked in and found she was 'upgraded' to a two room suite on the 4th floor where the bedroom was directly behind the elevator shaft. While she reported that the bedroom was quiet, the sitting room was quite loud with all the foot-traffic in the hallway by the elevators. This would seem to be in direct opposition to our profile's which request high floors away from elevators. Upgrade or not, you be the judge.