Or start at 03:06 during the track Futile Escape from Aliens. It's a theme that constantly builds, getting more intense and really gets your adrenaline pumping. So awesome he used many cues from it for the themes of the Marines in Avatar.
In Roger Corman's Battle Beyond the Stars, a cheezy rip-off of Star Wars and The Seven Samurai, Horner gives out a terrific theme. Corman used it again for the trailer of his terrible Fantastic 4 movie.
He also reused the music in several entire movies (Space Raiders, Sorceress, Wizards Of The Lost Kingdom and so on).
The soundtrack for Apollo 13 is consistently praised as one of Horner's most solid all-around efforts. To name just a few highlights: the aforementioned main theme with the patriotic trumpets, the famous launch scene, the edge-of-your-seat "Re-Entry and Splashdown", and last but definitely not least, Annie Lennoxharmonizing with herself beautifully over the end credits.
The main theme from Apollo 13 is frequently used on "teaser trailers" for movies that don't yet have soundtrack music written for them, to give them the appropriate level of awesomeness.
The main theme from The Rocketeer is just lovely; sweet and soaring and wistful. Then the melody repeats, picking up a bit of speed and another layer of orchestration each time through, until finally it's become an action theme so Bad Ass that it's been repurposed as background music for pretty much every other action movie trailer released since then.
Regardless of the fact it's a "kid's movie," the score from The Land Before Time is haunting and affective and is nearly Pavlovian in getting you to cry. Just watch this without remembering that first traumatic viewing.
The final scene ofBraveheart, wherein Robert the Bruce at last rallies the Scotsmen to independence, the music starting slow and then building and building to a glorious crescendo, intermingling flawlessly the leitmotifs for heroism and for Scotland as Wallace's sword is thrown in the face of the English oppressor.
For most of Avatar, the music is pretty good. It gets thrown into EPIC territory with the track 'War' It is better than sex.
And what about 'Jake's First Flight', at 2:15, where after two minutes of boys choir and native drumming it suddenly breaks into magnificent Christmas music? That'll sweep ya up right there.