So, we just got back yesterday from our Med cruise on Magic. We were in a 9C - room 2114 which is right near the aft elevators. We loved this room! We didn't have any problems with noise either from above or from outside the room with people going past. It was super convenient to just pop up in the elevator to Cabanas and the drinks station. Our room didn't have a connecting door, but it did have an extra drawer / cupboard unit that we didn't have in our 9B room on a previous cruise. It was really useful having the extra storage space.
We found it easy just to pop up and down the stairs to deck 3 for Cariocas, Lumieres, the lobby, guest services etc.
We would definitely choose this room again, or any in the 9C category on deck 2.
Hope that helps!
Claire