One to avoid is the BBLR (Bora Bora lagoon resort), the only good thing at it being the view.
I enjoyed the Hotel Bora Bora (An Amanresort).
However, if you never been there, you don't even go that far to be disappointed...