The Majesty is a great ship, my all time favourite!
The best cabins are the owner suites on deck 9 fwd. Then you have ordinary suites on deck 9. Some of them may have an obstructed view because of the lifeboats.
On deck 8 fwd there are category CC cabins with a nice viev. That is also a very quiet part of the ship, just behind the bridge.
Since you don't want people runnning by the winow, I won't recommend cabins on deck 7.
Deck 6 has some nice category C cabins all the way fwd. If you go more aft on deck 6 there might be some noise from the casino.
Hope you'll have a great cruise on "my" ship which was my home for almost two years