I stayed in a JS on my last cruise after the revitalization of the Majesty OTS.
Definitly try to stay mid ship (close to the Elevators as possible)
As for the noise....not so bad for me...we stayed in 1540 forward.
If noise is a factor, try to stay underneith the Windjammer cafe vs. the main pool deck.
As for rba0701:
Since the refurbishment, the Majesty of the Seas will be an amazing "short" getaway cruise for your family. She offers the same amount as restaurants as the Carnival Libert...places like the Main Dining Rooms, Johnny Rockets, Compass Deli, Windjammer Cafe, Cafe Latte-tudes, Sorrentos, and Freeze Ice Cream Parlor.
As for the staterooms, that is a different story. If you a traveling with 2 people or less, book a Superior OV Stateroom Deck 9. These re bigger than the staterooms below that measure 122 sg ft!: but the new bedding is INCREDIBLE along with the Plasma TV's. If money isn't a problem, BOOK A SUITE! They are amazing!
We leave in 70 days on her again...can't wait!