trebol42 - If you are flying to Moorea then the IC might be the best bet as it's close to the airport. For one night I'd get the cheapest room available. This is not a hotel I would ever recommend to anyone - it's a Travel Agent sort of place full of people using it as an airport motel, which incidentally was its original purpose as a Travelodge, then the Tahiti Beachcomber.
If you are taking the ferry across to Moorea, then you should stay in town. The Tahiti Nui is excellent and you can walk to the ferry pier from there.
As I've said many times before, it's sad people ignore Tahiti. There is much to see and do there and a rental car makes for a pleasant few days.
The Moorea Hilton is fine if a little cramped as they have too many rooms for a relatively small area. I've stayed at the Moana on Bora Bora - a nice beach but it lacks a view of Mt Otemanu, as does the Conrad which faces out to the ocean. It's been upgraded recently so should be OK.