Came across this interesting app while searching for something to enable manual controls of the iPhone camera. Quite fun. Not only I can take long exposure shots, light trails and multiple exposure shots are possible too.
Multiple exposure with motion of the street lights
Multiple exposure of the street lights and window frame