Yeah, if you're trying for specific effects like these, with moving ambient lights, by all means freeze your model. As nathaniel said, it can be hit or miss. For static background scenery though, a flash is kinder
asking your subject(s) to stand still is possible. i've posed for night portraits with light trails (from traffic on Orchard road) before. however, not all shots were good (sometimes 1-2 people in the group photo moved). f/1.4 or f/1.8 lens might work if you are okay with a blur background. for sharp background (by stopping down the aperture), flash helps, but it can't be too overpowering (and you have to meter correctly) if not you might end up with a dark background.
I saw pros that make the model stand for 15-20 second exposures and use a flashlight to do light painting before. The pics come out really impressive. Don't worry about the 'eyes on you'. Just do your own magic.