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.
I'm on the Riviera deck on my upcoming cruise. We're usually on the Caribe, but once on the Aloha-which was great. I can't remember on my Carnival cruises, but I think they were usually on lower decks. I sailed on the Mardi Gras, Carnivale, and Jubilee. I used to think they were huge.
I noticed the funnel design is different too. The first cabin deck under the Lido is my preference, and mid to mid-aft. I am always needing to go to the cabin for something I forgot or need. The cabin I had last year on the Legend was perfect, I could walk a few feet and down from Lido and be at my cabin.