My first honeymoon was to Tahiti Islands. We landed on the main island, Tahiti and took a flight immediately to Bora Bora. I only wanted to go because of my name, DUH. We stayed few days in Bora Bora in an over water bungalow and then headed to Moorea Island.
Tahiti is more rural and less resort like. Moorea had choppier waters than Bora Bora.
Bora Bora was the best, just like me. 😉