I would guess probably at night, just because the ride will have warmed up and will probably travel faster. Also, I expect that alot of the ride will be dark, making it more exciting at night.
However, I have a feeling that any time will be a good time to ride.
-------------
...and enjoy the rest of your day at Cedar Point, The Am-aaaa-zement park!