It has been about 4 years since we went but the night tour was fantastic. Along with the headset tour just like you get during the day, there were also several park rangers who were featuring live presentations on a variety of subjects in several areas around the prison.
The view of SFO at night was just incredible
I highly recommend the night time Alcatraz tour and the day time Bay cruise under the Golden Gate.