A note on Bora Bora and the rest of the Tahitian Islands: I went there for my honeymoon, and Moorea was the best of the islands. The people were friendly, and the water was beautiful. It's a small island, and you can get around the whole thing on a bicycle if you want. We stayed in a bungalow that you could jump off the balcony and land in the water. We fed fish there every night and day, and there were tridacnid clams in the water right under our balcony, and also an octopus. Large stingrays would swim in and out at night, and you could swim from the lagoon out to the reefs, which were all under 10 feet deep on one side, and then down to 30-40 feet on the other side. On Bora Bora, the people were jerks, they treated Americans like crap, and although the island was surrounded by beautiful waters, I didn't like it as much as Moorea. Also, depending on where you stay (most of the resorts are on small islands surrounding the main island) you might be severely limited on when you can go to the main island. Tahiti itself is nice, but it's pretty dirty. We stayed in Papeete for only 2 days, and it was neat to see, but it's really a very dirty place, and the water is brown as is the sand. Did not compare as far as beauty of the water was concerned, but it did have cool stuff to offer like a lot of shops and the market (where you'll see to your horror all the fish that you'd want in your reef offered for sale as food for pennies). HOWEVER, there is not much to do after sundown on these islands, except go to a restaurant. By the way, with the exception of Top Dive on Bora Bora (which I think is American owned and operated), the food generally sucks, the sea food all tastes rubbery as if it sat around for a few weeks before they cooked it, and it's VERY EXPENSIVE. By the way, one night at a hotel usually runs around $800-$1500 in a non-package deal, but you can rent a house on Bora Bora for less than $3,000 for a month.
After our honeymoon, we went to Hawaii, and I found that it was nice to be somewhere in the states, although it was much more crowded. There was lots to do, and the people treat you like a tourist, meaning they cater to you.
By the way, your first concern about where to go should be based on when you're getting married, because depending on the time of the year, your options will be limited by rainy seasons. By the way, if you choose the Tahitian Islands, when they say June is the dry season, it's not. June is the end of the rainy season, and July and August are into the dry season. We were told the rainy season was in March and April, and June was the middle of the dry season, and it rained the first 2 days we were there and was overcast most days (although we still got fried through the clouds and patchy sunlight).