Moorea
We had a 2nd floor studio unit. We met some people there who had one of the over the water 1BR units and, while not large, was nicer than what we had. Cooking was still a hot plate. Our unit looked like it new drapes.
Bali Hai not withstanding, two weeks on Moorea is "more than enough time." I would seriously recommend that you consider staying on one of the other islands.
On our trip we stayed on Moorea and Bora Bora for a week each. The highlight of our trip was the week on a catamaran with Archipels Croisiers and we sailed from Huahine, to Taha'a and Raiatea, and then back to Bora Bora. We were in French Polynesia for three weeks. The cat is expensive, but it includes all your food, beer, and wine. Check it out. It is very relaxing and unforgetable! :whoopie:
I can't speak to Papetee we just flew in and out. If there is a Sheraton on Bora Bora you might want to consider that property. We stayed at the MaiTai on Bora Bora. It is a 4 star, and nice. We had an over the water unit and it was just great.
I don't remember where the Sheraton is on Moorea. I will check it out.
Cheers,
Paul