We chose the hotel because of the proximity to the beach, restaurants, etc, and we weren't disappointed in that regard. It's very centrally located and within easy walking distance of many things in Waikiki. The drawback with that is the rooms were very loud at night, especially rooms facing the street. You could hear every muscle car, loud conversation, drunken celebration, outside. The location and ambient noise isn't the hotel's fault, but if you're looking for a good night's rest, this probably isn't the hotel for you.
The reason we would never come back here was the cleanliness/smell/overall condition. We booked two hotel rooms on the same floor. The kids room had a pretty funky smell, but was passable. Our room was so foul smelling, I literally gagged. I'm talking cesspool/rotten garbage disposal bad. They were able to move us to a room on a different floor (not convenient having family on a different floor, but o well)... it also smelled funky, but at least I could bear being in there. The rooms were pretty dilapidated too... you expect a minimum standard of cleanliness and upkeep in a Marriott, and this was pretty beat up. Overall, pretty disappointing... even with the good location we will definitely stay elsewhere on our next trip to Oahu.