There seems to be no rhyme or reason to the "upgrade fairy" Anyone can be "upgraded".
And on VERY, VERY, rare occasions someone gets a REAL upgrade like inside to outside, or balcony to suite. I've even heard about inside to suite upgrades.
Other than those few real upgrades, the rest of the "upgrades" are illusions. They move you from a bottom deck inside to the next deck up but still inside. The ONLY difference is that there is an unmeasurable amount of movement less in the higher deck.. If you get moved up multiple decks, you almost always end up with one of the least desirable cabins on your new deck. [That's why it was available in the first place].
But don't worry about that, less desirable cabins are near elevators, near the front or back [under the galley or disco IS bad] and other locations that are perceived as not so hot. Front or back of the ship is fine and near elevators is fine as well. You will never hear the elevators..
But you are still in the exact same size and type cabin as before but you think you got something for nothing.
Don't be in any way concerned about "upgrades" just enjoy your cruise no matter which cabin you're in.
In 40 cruises I have only once received a real upgrade [inside to outside]. Nowadays we just book balconies on the stern and wouldn't accept an "upgrade".
Dan