Hi msheiny, to answer some of your other questions.

Yes, we rented a car on Moorea. It was no problem. We arranged it on the ship, but when we got to the dock, the representative of the company (forget which), was not yet there. So we took a car from another vendor. It was the local company (the name escapes me right now). The car we got was a bit of a clunker, but completely adequate. Just remember that if you need an automatic transmission, it gets much harder, and I would definitely have one reserved in advance.

Raiatea is beautiful, it's very untouristy, it's known for yachting mostly, I think. And pot--yes there is lots of marijuana on the islands, and we saw deals being made while we were on the 4x4 portion of the Faaroa river and land exploration.

The circle island trip also has a very nice episode of excellent snorkelling (deep water), but you need to sit back and enjoy the boat trip around the entire island.