Sleep

Sunset Hill Lodge, ☎ 689792648. checkin: 12h00; checkout: 10h00. Nestled in a little Zen garden with a little waterfall, maybe the cheapest place for this quality in Polynesia... 40€ to 80€.

Bora Bora Pearl Beach Resort and Spa, (Located off the main island, on the island motu Tevairoa). 50 over-water bungalows, and 30 more beach and garden bungalows. In order to get to the main island, regular boat shuttles take guests from the hotel's dock to a dock in Faanui, on the main island's north western end.
Maitai, Matira. Features (comparatively) reasonably priced over-water bungalows, not as splendid as its neighbor the Intercontinental, but nice. Get one of the over-water rooms at the end of the pier in which the rooms are located on as the water is deeper at these rooms. The other rooms are just off the beach and some are in water less than 1 ft. deep.
Intercontinental Le Moana Bora Bora. At the very tip of Matira on the main island. You do not get the views on the island (well, you're ON it), nonethess this is a classy luxury resort with all you can expect for the price you pay.
St. Regis Bora Bora. Newest and highest-priced resort on Bora Bora. Every room (100 in all) is a suite with luxury bathroom. Many of the rooms are over-water villas, some with pools or spas. Overwater villas have glass panels in the floors and under-villa lighing to make the lagoon shimmer in your room. Guests are 80% American, 80% of whom are honeymooners. Nicole Kidman and Keith Urban honeymooned here. Two excellent restaurants on-site, one by Chef Jean Georges. The angle of the view on the main island is impressive.

Source: Wikitravel.