Midship will have less wave movement (think of the ship as a seesaw, the middle of a seesaw doesn't move).
In the very far back, you wind up always walking to elevators because there aren't stairs in the back. Little more walking than midship.
For the same cat room, any size difference is probably negligible.
I envy you, I wish I was going again.