The flight to Bora Bora, if I recall, is about 45 minutes with one stop. It is a beautiful flight as you go over alot of the islands. Be sure and get on the left side of the plane. I would check to make sure when you land in Papeete that you can catch a connecting flight. I know to Moorea, Air Tahiti's last flight is around 10pm and many of the international flights don't arrive in time, meaning you may want to get a room for one night in Papeete. The Beachcomber or Le Meridian in Papeete are both fine for one night. The Hotel Bora Bora is one of the older hotels and is on the mainland - service is suppose to be superb and has one of the best reputations on the island. Snorkeling there is suppose to be great. I have never heard a bad word or comment. The Bora Bora Lagoon Resort is on a motu and I believe has just been renovated. I stayed at the Bora Bora Pearl Beach, but have read many great comments on the hotels you are considering. Go to Tahiti Explorer message board and you will get all the information you need to make a decision.
Sally