8th Fl Aston Waikiki Sunset had everything we needed. Good location, close to the beach and close to popular spots in Waikiki. Oahu, as a whole, has a pretty good bus system so we took advantage of it with a bus stop a block away. Don't forget to get a HOLO card for the bus. One of the best things about this unit are the Diamond Head views from the balcony.
However there are a few cons.
If you're remote based and require reliable Wi-Fi, you may need to maneuver yourself in the unit to get the best signal. The unit does not have it's own Wi-Fi router/modem, you're actually sharing with the building/another unit. Aston Waikiki Sunset operates as a hotel and residential/condo.
The refrigerator could have been updated, it's a little dated and the ice maker in the freezer didn't work....o no frozen margaritas for you. I didn't notice ice machines for the hotel guests but there is a mini-mart in the building with all your basic necessities. They may have had ice, not sure. Saving grace were the reusable ice packs and the collapsible insulated cooler the host had for guests to use, we used those items everyday.
Since you're on the 8th floor noise from the street was limited. But during our stay there was extensive construction underway on the two units across the hall which started promptly at 9am and ended at 5pm. Sleeping in was a little difficult but good news I believe the construction is due to end soon.

The host promptly replied to inquiries when needed and was accommodating to the issues that came up during our stay.
With the new COVID-19 travel requirements, be aware Aston Waikiki Sunset needs to take down your Hawaii entry QR code information., so keep that handy. The building also required a short form filled out by every guest at check in.