Mid ship has the least motion. Plus the mid ship elevators (on the Dream/Fantasy) provide easy access to the pool and buffet/quick dining areas and the pool. I've also heard from a few others that its a bit noisier in the rear section of the ship due to the engines.
GET UP TO A $1000 SHIPBOARD CREDIT AND AN EXCLUSIVE GIFT!
If you make your Disney Cruise Line reservation with Dreams Unlimited Travel you’ll receive these incredible shipboard credits to spend on your cruise!