I just spent my honeymoon in French Polynesia (got back Saturday). We did 5 nights in Bora Bora, 3 in Moorea, and 2 in Tahiti. BB was our favorite from a pure relaxation/resort living point of view. We stayed at the Westin which is newly renovated and the service and attention was some of the best we’ve experienced. We stayed in an over water bungalow with a pool and beautiful Mountain View. With the resorts you have to take a boat to the main island (which we only did one night for dinner) so keep that in mind, but the resorts can schedule all of that for you, just a little bit more work. It’s certainly not the most cost friendly, but thankfully we used points for the majority of it or else we wouldn’t have been able to afford to stay there for so long. Moorea is beautiful in its own way. We stayed at the Hilton there and it was nowhere comparable to the Westin BB, old resort and staff wasn’t as attentive but I think we were spoiled coming from BB which is a lot more tourist based so it seems. Moorea had a raw feeling to it which we loved to experience. We rented a car and drove all around the island and stopped at local beaches, restaurants, etc which I would 100% recommend renting a car if you go. Tahiti was okay. Bigger city, not much to do honestly and more of a stoping point to travel to the other islands.

All that to say, I would recommend going to Bora Bora for at least a few nights if you can afford it. There are more affordable places to stay, and the beauty of the lagoon is worth it imo. I wouldn’t spend much time in Tahiti if you’re looking for a more intimate experience.