I haven't bareboated down there, but I have sailed my own boat down there. The Society Islands run south east to north west, as do the trade winds. If you rent from Tahiti or Moorea and sail to the Isles Sous le Vent, as far as Bora Bora, you will almost certainly have a long miserable beat back to where you rented the boat from.
Though it probably will add some money to an already expensive boat rental, were I to rent a boat in French Polynesia, I would request a one way trip to Bora Bora, which would give me much more time to enjoy each island, because you don't have to plan your return trip past islands you've already visited.