I love this shot. It’s totally unattainable in “AUTO.” Your DSLR is crying for you to spin that dial and add some human intervention to the exposure process. With a little creativity you can use your DSLR to capture or create something that’s not normally visible to the naked eye using a long duration exposure.
In Matthew Fang’s “Super S.” (above) you’ll notice the headlight trails and other standing lights are overexposed. His decision was to run a long exposure, capture the detail in the naturally lit elements and not worry about the lights which have none. This 117.4 second exposure was captured at f/22 with a 14mm lens. With a wide lens and small aperture he got a huge depth-of-field which made focusing (often difficult in the dark) a lot less critical.
Most handheld pictures need fast shutter speeds otherwise the natural shakiness of your body will render shots blurry. You can fix a lot of things in photography. Blurry isn’t one of them.