DH and I went to Bora Bora (and Moorea) for our honeymoon almost 4 years ago. It is very, very remote. Less than 10,000 people on the island. The weather is beautiful and the scenery is breathtaking.
The travel is a bit taxing. We left from LAX International and flew to the main island of Tahiti. From there, we had to take a small prop plane to Moorea, then a bus to the hotel. It was truly a full day of travel. Riding in the small plane was a little nervewracking, but we did OK. The thing that DH missed the most was his Peet's coffee. In his opinion, the coffee was weak.
hotel
The food is super fresh and tastes great. Don't expect to upgrade your room while you're there, because 99% of people who are there are on their honeymoon or anniversary. We didn't get any type of special treatment since we were on our honeymoon.