on the motu day, you won't need an excursion. You just snorkle right there, and they have kayaks you can use as well.
In Moorea, we rented a car at the dock on day and did our own touring. It was really fun to drive around the island. We went up to the Belvedere, went to a factory where they make a very strong Kahlua type liquor, went to a couple of beaches.
I would think you could do the same on BoraBora. There is a motu there too that is included, but not a extensive services as the other. You can snorkle and kayak though.