I've seen time-lapse night sky videos before, but this one that I found on Neatorama during the week is particularly impressive. It may show the sky in a way that you can't with the naked eye, but it still gives an idea of what is hidden from us by light pollution. Watch in full-screen.
More information on this video (including a couple of meteors captured on film) can be found here (I never did see the deer!).