A personal favorite: the main titles from Willow Whistful, but powerful. I think it was by, uh, no, wait a minute, it’s on the tip of my tongue, uh, gee, gosh, who was it, uh, maybe, er, was it, uh, JAMES FREAKIN’ HORNER, THE GREATEST MUSICAL GENIUS EVER TO PEN A MOVIE SCORE? The fanfare was good enough to show up in the trailer for, like, every fantasy movie made for the next fifteen years, I think.
Many of my favorites have already been mentioned: Superman, Raiders, Batman, and Star Wars, undisputed champion of stirring scores.
Apollo 13, also by Horner, is awesome. Soaring, that’s what it is.
I also think Jerry Goldsmith’s titles for Star Trek: The Motion Picture, adapted by Dennis McCarthy (I think) into the Next Generation theme song, is the best Trek fanfare (though I like the subdued theme from DS9 a smidge better overall).
And, what the hell, Stargate hasn’t been mentioned yet. Builds slowly, but has excellent vocal work.

