DPS have a great post on the art of shooting light trails. I've tried this on film (Vegas below) and with my little IXUS digital.
The Strip (Canon EOS Film). Wasn't going for light trails but I like these
Hanoi Balloon Seller (IXUS Digital). Although on manual I couldn't stop it down for longer trails without over-exposing the scene.