We did a 17 day Tahiti cruise earlier this year, followed by 4 days in Bora Bora. It was nice in Bora Bora, but quite expensive. We did one of those over the water bungalows which I enjoyed a lot, and the place we stayed had a "free" breakfast that was delightful every day. We did not rent a car, walked to shops and restaurants. We did have a stop at Moorea, and there was more to do there, but I think you would require a car there. I am quite certain you could rent a taxi very easily, too. Travel agents that were on our cruise were surprised we did our after trip in Bora Bora instead of Moorea. We did get on a boat from the cruise ship to Bora Bora, and it did cost a little more, but they retrieved our bags from inside the terminal and they were already on the boat headed to Bora Bora. Then we took another boat from Bora Bora to Tahiti at the conclusion of our stay. Hope your trip is as memorable as ours was.