We wanted to play a round as well....until we checked out the prices including clubs....yikes. However, we are totally spoiled to play dirt cheap where we live, so it might not be that shocking for someone who plays "nice" courses regularly. The one at Ko'Olina must be pretty nice, since LPGA plays there. Plus you can just walk over from Aulani. Go google it.
There's also what I think is a municipal course right in Waikiki, but it wasn't that scenic.