Where’s the best cabin on an ocean cruise:
Mid ship. Forward cabins will have more movement. If you are prone to seasickness stay mid to aft.
River cruise: all cabins offer the same experience. But the further back, there will be more engine noise. There are typically no waves on the rivers.