There are plenty of bright ones you can see with the naked eye, but they flare up and disappear in a fraction of a second (and appear to last a moment longer as the after-image fades in your head.) The longer exposure is partly to increase your chances of capturing one, a little like shooting lightning, and also to give more exposure to the stars.
Photos don't really capture how dramatic they can look in real life though. That visceral sense of speed and scale, maybe something similar to a feeling of sudden acceleration such as take off in a plane. For me, movies don't really have much emotional impact for that sort of thing either. Especially the way modern CGI tends to be used; you know, that pretty but hollow, excessively storyboarded look... Even the videos of that big one that came down in Russia recently, spectacular as they were, are quite a bit removed from catching your breath as a direct witness. Maybe that's just my cynicism.