I didn't go to Bora Bora, but I just got back from Moorea, French Polynesia. From what I've heard, go to Bora Bora if you like touristy areas; go to Moorea if you like the untouched environment.
I don't know where you're coming from, but the plane ride is *awful*. Papeete only has one flight out and the airport is closed until close to flight time.
What's your budget? I *loved* the hotel I stayed at in Moorea. Expensive, but, it's absolutely breathtaking.