Invasion of the Body Snatchers. The old one was better, the new one was still pretty effective, though.

Now, the movie that is just one long adrenalin rush, without being nightmare inducing, is Aliens. But it MUST be viewed on a large screen to have this effect.