Sorry for the late reply
There are definately affordable apartments on the island, and in Honolulu/Waikiki in particular. I was looking at one for $1500/month 1 bdr, kitchen, in Waikiki at one point, but while Hono is a fun place to visit, jeeeeeezus is the traffic bad. But there is some good affordable housing.
There's also a whole lot of unaffordable housing too...
Where I live, I'm literally 30 feet from the beach, pay about the same in rent, and is a nice clean place.
Not much in the way of nightlife here though, but that's what Honolulu is for