We spent over 10 days on Tahiti, mostly due to a public service strike preventing international flights for a week, plus 4 on Moorea.
My insights:
IC is a decent facility, they offer a shuttle bus to the city around $2 per person.
IC Faa'a Tahiti do not bother with an overwater bungalow, the starfish essentially prevent you from swimming out, the lagoonarium they have is not as good as the Moorea one but still interesting.
The Le Lotus restaurant at the IC was fabulous, especially when travel insurance was paying for the meals,
you can even go just for dessert but there is a dress code I saw them enforce.
IC show night, you can eat a la carte if you want not the overpriced buffet, also just sit on the lounges and watch the show.
Public buses travel around the island and IIRC there are stops at each hotel.
For self catering getting milk in FP is not easy we mostly saw milk powder and occassionally UHT milk, I suggest you get cartons of UHT milk from home, customs will let it through, if you plan on having cereal for breakfast, bread is typically wonderful french style even from the supermarkets, but bring your spreads as they are expensive.
I recommend hiring a car for at least 1 day if not 2 for Tahiti, there is plenty to see around the two Tahitian isles (joined together).
Roulottes especially on the waterfront are clean and safe to eat from offering a variety of cuisines as well.
I recommend some days in Moorea, especially if you cannot afford to go out to BB or Ta'haa, as you can ferry in 30 minutes and still lots of good resorts and restaurants happy to do free pick ups.
Transiting in AKL is dead easy as othes have said.
In my mind Tahiti is similar to Fiji, it can be cheap if you are prepared and also able to leave the resort confines, or expensive if you limit yourself to the resorts.