I've asked people with such requests why they'd like to be higher up and the vast majority of the time there is either a long silence or "I don't know, I just thought those were better cabins" is the reply.
Hence the somewhat misguided devotion some have to getting an upgrade, even though it is virtually always just to the same type of cabin on a higher deck.
We typically are on a higher deck because that is where the balconies and suites are, although even on those times we were in standard cabins I wanted a higher deck. This is purely because I like to be close to the pool deck and don't like elevators. The highest "cheap" cabin we ever had was an inside on the Sun Princess. It was immediately behind the bridge area. When we opened our door we were staring at the crew entrance. Cabin R305.