Confirming honu and BB above, I do HNL once each year since my sister lives there. The HHV was the first place I'd stayed at there in Oahu about 20 years ago and I found it overwhelmingly large and somewhat impersonal.
The New Otani is always my first choice for the last six years and it is a tremendous value, IMHO.
The Sheraton Moana Surfrider is lovely and superb and it is my perrenial second choice and my wife loves it. It's the place where one of her friends were married soon after the renovation. Breakfast overlooking the beach here is as good as at New Otani under the RLS banyan tree!
The only condo type place I've ever rented for a week was at Discovery Bay and it was okay but no big deal either and it was about twelve yeras ago.
The Halekulani has for sometime been the place to stay here but I never felt it was worth the rates they typically ask. I've preferred just to go to La Mer for dinner or for the great breakfast. Patricia was the manager here (five years ago) and was great but I'm not sure if she is still there.
Not too crazy about the Turtle Bay Hilton, here I've visited but never stayed. They do have a special rate deal going on now for about US$149./night so you may want to check out the Hilton website if you haven't already.