Wow - what a trip.....two amazing places. I have traveled all over the world and this was one of the best.
Moorea is a great place to stop if you want to include an extra island. We stayed at the Intercontinental in a full OWB and it was amazing. The hotel was great but the marine life was second to none. From our OWB we saw sharks, puffer fish, rays, parrot fish, and much more. The snorkeling is def better here and the hotel was an A+. We did the topdive and the tiki village tour which were both great. It had two infinity edge pools that were both wonderful.
Bora Bora was as stunning as we thought. We did six days here which was the perfect amount of time. We originally were booked in the INC Le Moana but quickly changed hotels to the Thalasso. Let me be very frank, we did not like one thing about the Le Moana. It was extremely windy and the waters were rough. There is no protection from the wind and it is always an issue. Unlike the other hotels, the lagoon is rough and choppy. The OWB also are subjected to gale force winds. The hotel is also in need of renovations and was nearly empty. The restaurants and bars had nobody in them. The wind on the dock was so bad you could hardly stand. Nobody was in the water due to the winds and chop. Lastly, the very small pool was so cold that people were using wetsuits to swim. I DO NOT recommend this hotel at all.
Now for the great - the INC Thalasso was stunning, amazing, and suberb. The grounds are immaculate, the infinity edge pool was glorious, the waters were as clear and calm as a pool, and the OWBs are like something out of a dream. Floor to ceiling glass, glass coffee table, three rooms....words can't describe it. The staff was extremely friendly and helpful. The spa was killer (glass floors over the water). There was nothing bad about this hotel....it is right up there with the St. Regis and Four Seasons. It is completely protected from the wind and always has nice calm waters and no heavy winds.
Things we recommend - Charter a boat for 3 hours with your own captain (we did an island tour, swam/fed the sharks (lemon and blackfin), snorkeled in the coral garden and then went to a private motu. Bloody Mary's was good and a fun night out. The spa was great. Best meals were at Matira Beach and La Bounty.
As others have said, stop at the grocery store and load up on snacks, beer, soda. A coke is $6 at the hotel :-)
Any questions let me know.......you will love Bora Bora.