I have dove a number of times in French Polynesia and never experienced much of a current. There definitely is no drift diving. I agree with Doug, the most amount of current or drift I have experienced is in Cozumel.

In my experience you don't have to worry about seeing sharks in Tahiti. They are on most dives. I also have gone with Bora Dive Center when they fed the sharks and it was interesting, but I truly enjoy going with the experts on the ship. It is just easier to do straight from your cabin to the sports marina, out in the zodiac, and then back to your suite. If you go with an outside operator you have to tender to shore first and worry about arrival and departure times.

I would say the least interesting dive would be Table Top because it starts shallow and is more of a beginning dive.

Cindy, I am not a strong swimmer at all and I passed all the testing so I am sure you can do it. You will have more one on one attention from divemasters on the Paul Gauguin than I have in over 50 dives.

I would definitely recommend diving in Rangiroa. It is highly regarded in most dive magazines. Ask the dive masters which dives they recommend the most. The water and visibility can change and they are most up-to-date on current conditions. I have always found them to be most helpful.