One of the big factors is what deployments are like. Personally I'd rather be on solid ground wherever I am deployed than on an aircraft carrier.
Then you probably want to stick with the Air Force or Army aviation programs. Navy, Marine, and Coast Guard pilots all have the opportunity to eventually deploy on a ship at some point. Maybe the only exception are USMC Herc pilots, but I'm not sure.
Additionally in the Navy what are port calls like. I have good friends who do Intel and love port calls ,they said they had a blast in the Philippines and Australia. For port call is it a week of exploration of whatever country you are in? How does it function?
Port calls can be lots of fun. You usually still have work of some kind and a duty requirement to fulfill so it's not completely free time to explore foreign ports of call. You will often need to stand duty at some point during the time in port, which means you will have to remain on the ship for 24 hours unless you can finagle your way into being part of the shore patrol which is
ALWAYS a good deal. Sometimes the squadron and/or air det will get themselves a hotel room in town. I can't speak to what occurs there but it's essentially a crash pad so you don't have to go back to the boat.
The actual experience out in town differs depending upon where you are. Some spots are great, others not so much. You will likely have a lot more fun and be able to stay out in town a lot longer when pulling into Cartageña, Spain, versus somewhere like Karachi or Dakar. With the security concerns of the modern post-9/11 era, you may or may not be able to stay out overnight in town. Also, the OPTEMPO of the ship has a say. Sometimes you get a week in port, sometimes it's less than 24 hours. Other times you can have operational requirements scrub your port call entirely.
And then, sometimes Neptune and the Fates smile upon you. For instance, the harsh winter weather in the Mediterranean could force your ship to have to head into anchorage in Augusta Bay, Sicily, and you will find yourself suddenly and abruptly ashore in the sleepy town of Augusta. When that happens, make sure you partake of the Sicilian rabbit and plenty of vino Siciliano. When interacting with the locals, remember the phrase "Ciao, bellissima!"