The condo is exactly as described, with a gorgeous view from the balcony. We spent a lot of time out there enjoying the view.
The roosters crowing really didn't bother us, and the fans and breeze (and closing the curtains during the day) kept the place pretty cool even though it was regularly 85F outside.
The kitchenette was exactly enough to make simple breakfasts. There's a hotplate but the provided pans are small, so don't expect to make a fancy dinner or anything.
Location was great. We walked to hideaways beach and queens bath, which was awesome, and loved that we didn't have to buy or rent our own boogie board, umbrella, or snorkels! So convenient and thoughtful.
The only downsides were occasional noise from the road/parking lot, and thin walls (but you could really only hear the neighbors from the bathroom, since it doesn't seem like any other walls are shared).
Overall a great stay. We'd definitely stay here again if we come back to Kauai.