This might be slightly off the topic because I see that it is mainly discussing B/W while I use slides. I have taken a few night shots of London street Christmas Lights lately with a hand-held camera using a Provia 400 film. Using a tripod in such crowded streets would have been rather difficult. There is evidence of camera shake, so I can't say the photos are exceptionally good. Here are three examples from my flickrs page, if anyone is interested

http://www.flickr.com/photos/3203854...in/photostream

http://www.flickr.com/photos/3203854...in/photostream

http://www.flickr.com/photos/3203854...in/photostream