I would like to start off by saying this was an amazing location for our first time in Hawaii. You don't need my life's story so I'll get to addressing some of the things I see in other comments.
Listing Size: This is a STUDIO apartment in one of the busiest tourist cities in the world. It is on the small side compared to most anything on the mainland but that should not be unexpected. There was more than enough space for my wife and I. Of course the photos are going to make it look larger. You can tell that they are zoomed out to be able to capture the entire space. This is not uncommon for any housing listing.
Parking: I don't see this as an excuse to rate Scott's location lower. He clearly states in the description what the situation is. Additionally, this is similar to what you'll find in many of the hotels in Honolulu. Ask any local and they can confirm as well. And, as Scott lists in the description, parking is reduced to $20 a night if you rent a car from one of the companies in the hotel lobby.
Location: You're a little on the corner of downtown Honolulu but that doesn't change much. Nearly everything is within 15 minutes of walking distance. The farthest we "had" to go was to a Walgreens which is only 1.2 miles from the hotel. It took us less than 15 minutes to get to the Ala Moana shopping center or Waikiki beach with plenty of eateries in between.
The Hotel: I will start by saying Scott's condo was fantastic. It was clean, the air conditioner kept us chilly most all of the time (had to close the blinds during the day as the sun is far more intense than in the mainland), and it had all the amenities Scott lists. For the hotel itself, I have seen comments about roaches or bugs or even the dreaded bedbugs. SCOTT DOES NOT HAVE THESE BUGS. I cannot stress that enough. Scott operates this condo privately and maintains it privately. It is CLEAN. As for the roaches/ants that people have mentioned, while Scott does not have an issue with them, they are a common issue in the city. Again, talk to the locals and they can confirm it. Regarding the keycards: sure, they were a little inconvenient to have the deactivation risk if you have them close to your phone. Just don't have them close to your phone. Like, it's really not that hard to prevent. The hotel is a little outdated with they're card system but I imagine it's costly to update something like that for 38 floors. As for the staff of the hotel, we did not encounter a single rude person the entire stay (or on the rest of the island for that matter). They talk about "southern hospitality" in the southeastern United States and I can say that what we experienced on Oahu put that to shame. Everyone was beyond pleasant and friendly.
The Host: Scott was wonderful in all regards. We had an issue with a damaged keycard when we arrived which Scott promptly resolved. Any concerns or questions I had for him were responded to very quickly. He even allowed to check in a bit early as the cleaning staff had finished early.
In summary: this isn't your suburban 2000 sq ft house. This is a condo that is space efficient for a small island. You're also in a completely separate culture that is as close as I have experienced to a foreign country since I visited Europe. The condo was as expected, the location was wonderful, and of course, the price was beyond reasonable. If I ever stay in Honolulu again, this will be one of my top considerations.