Aft, aft, aft, and the farther back, the better! My favorite stateroom is 5650, which is as far aft as you can get. You definitely do feel more motion in the forward part of the ship. I've sailed in the secret porthole rooms (forward) several times, and there is a definite difference.
Barb