You really need to look at the deck plans of the ship you are sailing to know for sure. On the Destiny class ships of Carnival for instance all the activities other than the pool and buffet are on the lower decks.
I booked a guaranteed cabin on the Pride at a category which was one deck above the casino, shops, lounge, bars, atrium, et. al. so I could walk one flight of stairs and didn't have to use the elevator. Just my luck, when I got to the port they "upgraded" me 3 higher decks. To me, this wasn't an upgrade since I now had to take the elevators all the time. And it was at the front of the ship where you would hear the paying out of the anchor chain.