It may depend on where you are coming from. From the east coast, we had to go PHL to Charlotte to LAX, perhaps with a stop in between. Then we got on a very late (10 p.m.) or so flight from LAX into Papeete, arriving very, very early in the a.m. It was straight through, and very long coming from the east coast, but our rooms were ready at the hotel at 8 a.m. For others, they take you to LA for the night, and then put you on the1p.m. flight the next day, arriving at about 7 p.m. in Papeete. Ours was arranged all through RSSC, as we booked our pre-cruise with them.
As for those hotels in Bora Bora, I have only seen them, although on our cruise, my son and his girlfriend went over to the Bora Bora Lagoon for dinner as a Virtuoso included amenity and said it was beautiful. I think, however, that the Bora Bora Lagoon Resort may be on it's own motu and accessible only by boat (I know they went from the PG by boat)? Hotel Bora Bora is on the mainland, along the same road as Bloody Mary's and the place they take you from the ship for the wave runners. It is known in T&C and other high end publications as one of the finest resort hotels in the world. VERY pricey, but lovely!