I've very rarely gotten significant upgrades on hotels, even when I was Hilton Diamond. Most upgrades turn out to be things like higher floors or better views. They are nice, but in the end not that important to me. Even an upgrade to a suite isnt that significant.

What IS important to me is being able to get a non-connecting room, or a room in the corner, or on a quiet floor. So in that sense the status is worth it. But to me just an upgrade in what I look at or how much floor space I have isnt hugely important.