Your favorite song lead-in

--Light My Fire, the Doors
--Luka, Suzanne Vega
--In My Life, the Beatles
--Children of the Sun, Billy Thorpe
--Fooling Yourself, Styx

 

"Up Around The Bend" and "Bad Moon Rising" are two others from CCR that come to mind.

 

My all-time favorite:
For Those About To Rock - AC/DC

And, playing off some of your suggestions:
Day Tripper - Beatles
Paint It Black - Stones
Back In Black - AC/DC
Sultans Of Swing - Dire Straits
Jet Airliner - Steve Miller Band
Little Guitars/Atomic Punk - Van Halen

 

A few odd ones, mostly piano:
H.I.M.'s version of "Don't Fear the Reaper." If you've ever wanted to hear Enya rock out...
The Waterboys' "Don't Bang the Drum." You'll get chills from the combination of pounding piano and trumpet...just before a killer guitar kicks in.
Kate Bush, "Wuthering Heights." Used at my wedding.
Arcade Fire...where do I start? You'll find several great ones on "Funeral."
Nick Cave and the Bad Seeds, "The Mercy Seat." Death ballad fully worthy of the Johnny Cash treatment. Also, "Stagger Lee," which Nick swaggers through like a white 50 Cent (and it's just as NSFW any any gangsta rap).

 

good point, E. Both are great, but I'd have to go with the CCR version.

 

Eminence Front - The Who

One of my favorite rock songs ever.

 

The Next Episode - Dr Dre. and Snoop Dogg

 

U2, Where the Streets Have No Name --- particularly the live version.
Simple Minds, Waterfront --- and again, live version outstanding

 

More Human than Human - White Zombie
Battery - Metallica
So Caught up in You - 38 Special
Cold Shot - Stevie Ray Vaughan
Beautiful Day - U2
Sweet Home Alabama - Skynyrd
Don't tell me you love me - Night Ranger
Panama - Van Halen
Roll with the changes - REO Speedwagon
A passage to bangkok - Rush
Sex type thing - STP
Heaven beside you - Alice in Chains
Bullet with butterfly wings - Smashing pumpkins
Kickstart my heart - Motley Crue
LaGrange - ZZ Top
Jessica - Allman Brothers
The World I know - Collective Soul
Spoonman - Soundgarden
Love will find a way - yes
Come sail away - STYX
Need you tonight - INXS
Comfortably Numb - Pink Floyd

To name a few

 

--Working Man, Rush
--Abacab, Genesis
--Feels Like the First Time, Foreigner

 

Here's a few off the top of my head:

Agree with "Don't Fear the Reaper" - hell yeah.

"Sweet Child of Mine" -Guns 'N Roses
"Come On Eileen" -Dexy's Midnight Runners
"Had A Dream (Sleeping With the Enemy) -Roger Hodgson
"Back On the Chain Gang" -The Pretenders
"Money For Nothing" -Dire Straits
"Sultans of Swing" -Dire Straits
"Come Sail Away" -Styx
"Renegade" -Styx
"Hey Nineteen" -Steely Dan
"Cage of Freedom" -Jon Anderson
"Sharp Dressed Man" -ZZ Top
"Lunatic Fringe" -Red Rider
"Crazy Train" -Ozzy Osborne (duh)
"Wish You Were Here" -Pink Floyd
"Sausalito Summernight" -Diesel
"Aqualung" -Jethro Tull
"Don't Dream It's Over" -Crowded House
"Photograph" -Def Leppard
"Heartbreaker" -Dionne Warwick
"Jamie's Crying" -Van Halen
"Riders On the Storm" -The Doors

 

That China Boy splash at the beginning of "Abacab" does kinda break the silence, eh?

Pete's voice lead in "Dancing With The Moonlit Knight" deserves mention, too.