Orlando, hands down. Tampa is on the Gulf Coast, Canaveral on the Atlantic Coast. Orlando is inland, almost midway between the two. And there will be direct shuttle service from Orlando to Port Canaveral, probably nonexistent at Tampa.
Orlando is the place to be. However, if you're going in a day or two before, as did Susie and I, I recommend that you rent a car at the airport and turn it in at Cape Canaveral or Cocoa Beach, wherever the particular agency has its office,and take their shuttle to the pier. Piece of cake! Susie and I found it to be completely hassle-free!
The most convenient airport is Orlando - about 40 miles, Tampa is another 90 from Orlando. Most cruise lines offer transfers from Orlando to the Pier.
We have some great rates on the Mariner - an absolutely incredible ship and definitely a line that my clients love. Great service, wonderful activities both on board and on shore excursions. Let me know if you want a quote.
Time to Travel