Best start

[Qazimod]

Favourites of mine are Squarepusher Theme (Squarepusher - Feed Me Weird Things), Kickapoo (Tenacious D - POD), Fucking in the Bushes (Oasis - Standing on the Shoulders of Giants) and, if you exclude the intro, Break and Enter (Prodigy - ...Jilted Generation)

[silentmajority]

Ooh. Great thread idea.

Pet Shop Boys - Introspective.

I had a portable CD player at the time, walked out the shop, pressed play, and almost went back in again to complain they'd given me the wrong disc!

Oh yes - and the opera singer singing, "House!". Fantastic.

[shirubagan]

The intro riff to Blood & Thunder on Leviathan by Mastodon.

[Mr Do 71]

Favourites of mine are Squarepusher Theme (Squarepusher - Feed Me Weird Things)

Yes

[Joyrex-J9]

Do You Love Me? - (Nick Cave and the Bad Seeds - Let Love In)

[loathsomeleopard]

"Dearly beloved, we are gathered here today to get through this thing called life..."

Close, but I'd have to give it to:

"Oh Yeahhhh,

(riff)

In France a Skinny Man Died Of a Big Disease With A Little Name..."

In fact, just typing that has compelled me to listen to SOTT all over again.

[Clap Your Hands]

Do You Love Me? - (Nick Cave and the Bad Seeds - Let Love In)

yes yes a million times yes!

[Guest Magical Trevor]

Although several of my choices have been covered already, got to add Tiesto - "Forever Today" from the "Just Be" album

[Rsdio]

One that just popped into mind, the Rocket from the Crypt one-two punch of 'Middle' and 'Born in '69' on Scream, Dracula, Scream! 'On a Rope' coming straight after them isn't bad either.

[Goose]

Sympathy for the Devil - Beggars Banquet

[Rsdio]

Or Gimme Shelter from Let it Bleed.

[Takizawa]

Most recently Be from Common's Be

I'd actually go along with that, good call!

Some others:

Other Side of the World - Eye To The Telescope - KT Tunstall

American Idiot - American Idiot - Greenday

Holiday From Real - Everything In Transit - Jack's Mannequin

Real World - Yourself or Everyone Like You - Matchbox 20

But the winner has to be:

Debaser - Doolittle - Pixies

[shirubagan]

One that just popped into mind, the Rocket from the Crypt one-two punch of 'Middle' and 'Born in '69' on Scream, Dracula, Scream! 'On a Rope' coming straight after them isn't bad either.

I just spaffed in my trousers.

[Preacher]

I Wanna Be Adored - Stone Roses FTW

Yes.

"Yes" - Manic Street Preachers, 'The Holy Bible'

Yes.

One that just popped into mind, the Rocket from the Crypt one-two punch of 'Middle' and 'Born in '69' on Scream, Dracula, Scream!

Yes as well. My contribution is as follows:

Ode to Isis - And you will know us by the trail of dead - World's Apart

Jackie - Scott Walker - Scott 2

Introducing the band - Suede - Dogmanstar

Loads more, but these stick out like sore thumbs in my head.

[DonRumsfeld]

Mr Self Destruct from the Downward Spiral, can't beat a bit of THX

Hit The Lights from Kill Em All

Fight Fire With Fire from Ride the Lighnting (in fact Metallica's first 4 albums opened well)

Angel of Death from Reigning Blood. (again all Slayer's intros post the first album have been class)

Refuse Resist from Chaos AD (Beneath the remains, Arise and Roots all good intros too)

Cowboys from Hell

actually most of the great metal albums have a great intro and opener to grab your attention.