I have had cabins in the middle and the rear. The Aft is great. The last cruise we took the next to the last cabin on deck 6 port side aft the room is odd shaped but you get a balcony that is twice the size. We did not feel any of the motion except on the Mississippi.
Have a great cruise