The best view that I've seen of Honolulu at night was at the top of 'Alewa Heights. Most tourists don't hear about this place considering how it's a quiet residential zone. I consider myself lucky that the first week I'd moved to O'ahu, my friend directed me there. The sight had me fall in love with the island instantaneously.
I drove my uncle's rickety old van up the mountain which was an adventure in itself. The roads are steep and only worsen as you climb higher. I recommend driving up in a sturdier vehicle with good brakes. When you get there, you are treated to an unobstructed view of Honolulu at night and it is breathtaking! My eyes only strayed to make sure the van hadn't rolled down the mountain. Scary as the incline may be, I envy the lucky bums who live up there. =)
Sadly, I don't have exact direction on how to get there since I always went with my friend. We usually first enter Houghtailing St. off of School street, right on Hillcrest, left Skyline Drive, right on Puna, left on Aulii which becomes Alewa Drive and just follow that street up. There are curves and turns that may be confusing. If you look at a map, you can probably figure out your way to the top.
If you actually decide to go, be careful driving. And if you go at night, be mindful of the residents who will not be happy if noisy tourists start disrespecting their neighborhood.
