We have stayed in 5022 on the Magic, we liked the location, but did not like that it was an adjoining room - we had very noisy neighbors!
We are staying in 6506 (starboard version of 6006) on the Wonder next August. It was $500 less than the room next door and $2500 less than the veranda that we had originally booked. These rooms look like they have far less obstruction in the window than the secret portals on deck 5. On CC deck plans, they are still listed as a 9A deluxe oceanview.
As far as motion goes, I think if the sea is rough, the whole ship is going to feel it. It may be a bit worse far forward or aft, but not by much. We did a back to back on the Dream in room 7006 which is in the front corner of the ship. The first night when we were crossing the Gulf Stream, it was one of the rockiest nights we have ever had on a cruise! The second time we crossed, the sea was so calm you wouldn't know we were on a ship!