MSC Magnifica
Jr. Balcony Cabin
Room: 12010
This room is right below the Spa and is extremely quiet, however the door opens right into one of the 4 elevator banks and can get some noise from that. (Elevator ding noise is quiet).
If your itinerary includes a stop at Ocean Cay, the cabin has an excellent view of the lighthouse and island.