Led Zeppelin have put out several; "Kashmir", "Immigrant Song", "Black Dog", "The Song Remains the Same", but especially "Stairway to Heaven", which is not only their most famous song, but according to a Guitar World poll, it has the greatest guitar solo of all time.
"Immigrant Song" is used repeatedly by Michael O'Neil in the Posleen War Series to send his Mobile Infantry into battle.
"Dazed And Confused", where Jimmy Page plays the guitar with a freakin' violin bow! In the movie The Song Remains the Same, they play a 30+ minutes version of "Dazed and Confused".
"The Rain Song"? Heck, Houses of the Holy was an awesome album in its entirety.
For "Over the Hills and Far Away", it's a toss-up between the intensely beautiful acoustic guitar intro and the part when it abruptly transitions into headbanging hard rock (but is still tempered by the acoustic guitar throughout the song).
Rev Theory's "Hell Yeah" really gets your blood pumping, because who can say no to shouting "Hell yeah!" at the top of their lungs?
Almost anything composed by Jim Steinman, but his true Awesome Music would have to be Meat Loaf's Bat Out Of Hell album, especially the title track. Subsequent awesome tracks include music from 80s movie Streets of Fire ("Nowhere Fast", "Tonight Is What It Means To Be Young"), and the fantastically over the top ballad "Total Eclipse of the Heart" by Bonnie Tyler.
And the songs from their post-makeup days, which got closer to metal (or at least to hair metal). "All Hell's Breakin' Loose", "Into the Fire", "Heaven's on Fire", "My Way", "Under the Gun", "Tears Are Fallin'", etc.
For years, Foreigner had numerous hit songs that fell just short of #1 on the Billboard Pop chart like "Waiting For a Girl like You". In 1985, they finally created the song that put them on top, "I Want To Know What Love Is", a magnificent power ballad complete with a choir accompaniment.
"Jukebox Hero" makes you wanna jump on a table and rock out on an air guitar!
If you've ever wondered if Eddie Van Halen can work in short form, listen to his solos on "Jump" and Michael Jackson's "Beat It." He didn't always go in for the Epic Rocking, he could do tasteful stuff too!
Love's "Seven and Seven Is". If you're gonna go full tilt for two minutes, you've got to build up to a nuclear blast. Pretty intense for 1966.
"Revolve", "Queen", and "Roadbull" are some of the loudest, grittiest, and most jaw-droppingly spectacular pieces of stoner/grunge rock ever written.
"Cassie" by Flyleaf never fails to make for headbanging.
Heart has some amazing songs, but nothing beats this live version of "Alone".
Quiet Riot is basically the apotheosis of pop-metal. They blended all of the metal genre's elements - heavy blues, Gothic horror, insane riffs, and pinup sexuality - together into one inimitable package. All these years later, "Bang Your Head" is still terrifying. "Run For Cover" is probably their best song. And "The Wild and the Young" is an underrated gem: Frankie Banali's opening snare beat alone is proof that your world is about to get rocked really fucking hard.
Whitesnake deserve to be in the Rock and Roll Hall of Fame someday, if only because they were one of the most technically accomplished bands of the '80s. Their 1987 album is pure gold, with not a single bad track. "Children of the Night" particularly deserves a mention: it proved to the band's critics that, yes, they could be subtle....and yet still be badass as well. Same with "Kitten's Got Claws" from Slip of the Tongue.
Semi-fictional, yes but Spinal Tap has given us plenty of immortal musical moments. "Tonight I'm Gonna Rock You Tonight", for example, is an Ear Worm for the ages. "Stonehenge" is a thrilling celebration of ancient paganism. And while "Break Like the Wind" may be an awful title, it is a flat-out mythic song. But then, would you expect any less from Joe Satriani?
Theory of a Deadman, anyone? "Deadly Game" and "Invisible Man" in particular. Those songs are like a comic book come to life.
Alter Bridge. They definitely beat the shit out of Creed. Especially "Open Your Eyes" and "Metalingus" (best known as the entrance theme for the "Rated-R Superstar" wrestler Edge). Whoever thought Christian salvation could sound so badass?
"Isolation". Just...wow this song is pretty kickass. Especially in the choruses.
And, quintessentially, "Don't Stop Believin'". One of the most recognizable classic rock songs ever, and the lyrics and melody are absolutely Made of Win. In 2009 it became the top-selling catalog track in iTunes history. Steve Perry had the perfect rock voice: "Do-on't stop/Be-lie-vin'/Hold on to that fee-ee-li-in'/Stree-eet lights/People oh-oh-ahhh..."
German hard rock band Bonfire is truly underrated, it's a real shame they were never as well-known as the Scorpions with killer songs like Sweet Obsession.