Sunrise is the answer if you only make one trip. The point faces east into open ocean, the hole in Kukuihoʻolua is backlit, and you will have the railing to yourself. From Turtle Bay this is a twenty-minute drive; from Waikīkī it is an hour and a quarter and probably not worth setting an alarm for on its own.
Mid-morning is the standard visit and the busiest. Tour vans running the circle-island route stop here, so you can arrive at an empty turnaround and be sharing it with fourteen people two minutes later.
Late afternoon the light is behind you and flat on the islets, but the swell is often more dramatic and the neighbourhood is quieter.
Winter versus summer changes the character completely, as it does everywhere on this coast. From roughly November to March, north and northeast swells wrap the point and detonate against the cliff — spectacular from the railing, and a reason to stay well back from the edge, because spray reaches it. From May to September the water goes flat and glassy and you can see the reef shelf below.
Budget five to fifteen minutes. This is a stop, not a destination, and it works best stitched into a windward run between the Polynesian Cultural Center, Mālaekahana and the Kahuku shrimp trucks.