This place is exactly as edvertised. You’re about 15min (by foot) away from the beach. If you plan to stay in Waikiki/Honolulu the whole time, then this place is great.
If you want to explore the island I would recomment to rent a car or anything. I didn’t try the public transportation but it at least twice slower than using a car. (But really cheaper than a rental 5$/day)