Wendy and I did the Dolphin Watching Expedition at Moorea twice. The guide is a marine biologist who is passionate about his subject and equally passionate about not disturbing or taming the animals, but just watching from afar.
The first time we did it we saw lots of dolphins, but the second time we didn't see any. However, even the second time was a lovely chance to see Moorea from the sadly dolphin-less water as we searched.
We are hoping to return to FP next year, and I would sign up for this tour again. Lovely with or without dolphins, but better with. Plus the bonus that you are supporting the ecology program to preserve these wonderful animals and their habitat.
-- David