Here is an example how you can get unique and interesting photos when taking pictures at night.
This photo was shot in heavy snow storm and I haven't done that too often.
I had my remote controller with me and I setup the camera to my tripod on this road. I took couple of photos before I went into the frame. And then I just waited for a car to come to this scenery. I saw a truck in a the horizon and then I just waited till it passed me and stood still for 30 seconds.
There was not much processing in this picture. I remember darkening the right side a bit to give the contrast it needed.
Sigma 10-20mm f4-5.6
12mm f/5, 30sec. ISO 100