The real expensive rooms are the OW (over water) rooms and they start at about $1000 (depending on season).
They are not really worth the extra money unless you've got lot to spare... The French Polynesia is not the only place to get them, the Maldives also has OW rooms...