I stayed with a friend for over a month. Here are quick and dirty pros and cons.
Pros: location - 5 min walk from Waikiki beach and all the restaurants. Off of a big road that has bus stops, convenient but quieter. Cheap laundry downstairs. John, the onsite manager is responsive. Small bus functional space with a full kitchen and a table. Lots of natural light. Separate beds, both comfortable. Oh, it comes with a parking spot!! Amazing!
Cons: we used earplugs at night and never felt it was too loud but you might if you're sensitive to noise, toilet paper wasn't provided for long term stay after the first few rolls ran out, the bathroom is very tiny.
We loved our stay and would recommend it to anyone!