Hi Trish,
Both the dives were great. Our weather wasn't the best in Raiatea but the diving was great. Got in the water and there were six sharks circling the boat further down in the water. They were going to take us to the Bora Bora pass but because of the weather they couldn't. The private dive in Moorea was great and that is where I got to see the Nemo fish. We saw two to four adults ones and a couple of teenagers. It was great.
Good luck with whatever you decide - I don't think you can go wrong diving in either spot.
Have fun,
cruzboun