I think the view would be good any time of the day; you just want it to be relatively clear.

Hi, this is a 15 to 20 min stop on the way to other attraction. Just for Nu‘uanu Pali it is no point in getting Uber and be sure you will not get to it for return journey. Still this is what you want you can pay 15 to 20 min waiting charge. You should take some trip to various place in this direction instead of Uber, you can hire a car and drive on Nu'uanu Pali Dr and stop for a while at the look out point. ( I visited Byodo-In Temple, Haleiwa ( For big waves) 2 to 3 hours, make a quick stop at Laniakea Beach (Turtle Beach) and Sunset Beach Park )1 to 2 hrs . Hope this will be useful.

Think it be best to rent a car

It’s a stop and look location..nothing to do in particular just a view site..

Yes you can take Uber or Lyft up to the Pali Lookout. It would be rather expensive depending on where you are starting from. You would also probably have to pay the parking fee. Renting a car for a day would be easier and I suspect cheaper. Stopping on the way to the North Shore would be a great way to maximize a one day rental.

I think it's just an "honor system" to pay if you decide to stop, park your car and walk up to the overlook. No charge for just driving through.

Any car can get into the lookout parking lot.

No admission charge, but they do charge for parking. Also do not leave your valuables in the car.