Probably late, but I stayed at the Hilton (overwater huts) in Moorea in January. Some pics here: http://www.cjcphoto.net/polynesia2015/index.html
I arranged some dives with Topdive, and the experience was kind of comical in terms of things going wrong. Van picked us up at the Hilton and took us a short drive to Topdive, which was a located in another resort a few miles from the Hilton. Took a long time getting things organized, and got on the boat. Newish divemaster (6 months there). We then drove the boat past the Hilton to another bay where we tried to pick up a couple of divers from a cruise ship. They wouldn't let us dock at the 'good' pier as the cruise ship commandeered it for tenders. Docked at a different one and picked up the two divers. They wondered 'where's our gear? we're renting everything'. Ok - drive the boat all the way back to the Topdive location to pick up rental gear. Then back (in front of the Hilton!) for a dive, and it's now been 3 hours since leaving the hotel. And ... OOPS, they use DIN connectors, and MY gear does not. And there are no DIN adapters on the boat. However, the divemaster waved over another dive boat and borrowed some so we were good to go. Finally into the (warm, clear) water at about the 3.5 hour mark.
Diving was OK, but not spectacular. There are certainly better locations to dive in French Polynesia.
I think the Topdive center might have been at the Intercontinental. We ate lunch there, and as anyone can tell you, it's VERY expensive to eat in French Polynesia, especially at the expensive resorts. Hamburger, salad, diet coke and bottle of water: $60.