Moorea Beach Club is nice because you can avoid the crowded pools and masses of children. However, the wait is extremely long to get in, so you have to wake up early to wait in line before they open. There is also a $10 charge to get in.
It's fun to go once to check it out, but I wouldn't go back again. Guys think there will be tons of hot, topless women there...but in reality for every 50 women there, there might be 1 hot one. And sorry guys, the topless ones are overtanned old ladies with implants. (Visualize the lady from There's Something About Mary)