That was my cabin on the Magic! Its a Cat 4 familiy room in an excellent location not too far from the stairs and also has a good balcony.
The familiy enjoyed it a lot.
It was not noisy, the only time I noticed anything at all was when they had a deck party above in Mexico.
I am a light sleeper and would notice anything, we live in a road without traffic at home so you get used to it and notice anything!
You could get to the main deck quickly or the lifts and we loved it!