most people think of the South Pacific or French Polynesia the name “Tahiti” immediately springs to mind. While it is the most populated island by quite a bit, Tahiti isn't nearly as secluded or even exotic as many other smaller islands in the region. Moorea, for example, is a short ferry ride away, and it's smaller and more beautiful as well.
The main thing that Tahiti has going for it is that every flight into or out of French Polynesia goes through the main Tahiti airport, so it's a tranfer point for every guest, regardless of whether you are staying on the island or not. Also, the flights tend to arrive at odd hours, so some guests are more or less forced to stay on Tahiti on their first or last night.
(Interactive map below)
Fortunately, there are two overwater bungalow resorts on Tahiti itself, and both are quite close to the airport, and both are moderately priced. And as mentioned, you can take a ferry to Moorea if you are already in Tahiti, or a very short flight if you are just changing planes on the same day. And there are 4 excellent overwater bungalow resorts there, plus a more basic resort that claims to have invented the concept and still has amazing views.