A couple times ago while at the point on the last ride of the night for MF my buddy and I got the front seat. There is a point in the cycle where the lights go out on the supports and they just happends to do this while we were going over the top and made for a cool effect.
Here is my list for best rides at night.
1. Millie (as evidenced by my signature)
2. Magnum
3. Maverick
4. Raptor
5. Corkscrew (the lights on the corkscrew supports are sweet)
I know you won't get to ride all of these but try to get as many as possible. Riding at night is probably one of my favorite things to do, and the thing I most look forward to when visiting a park.
Millenium + front seat + closing time = pure bliss