We figured this would save us some north shore driving time, and be a different feel to staying in Honolulu. It's a nice little hotel setup (a number of small buildings) in a quite residential neighborhood. The common use BBQ facilities and the full kitchen in our room were excellent. I would say for longer stays, you'd be able to save a significant amount on food this way. We cooked up some nice fresh fish on the grill along with some grilled bread. This isn't really a resort in the usual sense, though they do offer some kayaks, and definitely read through reviews before getting excited at the relatively low cost. This is a fine place to stay, but ended up not really saving us a lot of driving time. It's a long way to restaurants for example.
Anyway, staff was great as well, and this felt so much lower pressure and less corporate than pretty much any other place I have ever stayed on Oahu.