Those songs...

[mip0]

This one right now (almost, I now what you're talking about and this song doesn't quite do it but it's the closest to it at the moment. Ask me a month ago and I'd say "Dust In The Wind".)
"Help yourself" by Sad Brad Smith

Spoiler: From the movie Up In The Air

 

[RyQ_TMC]

Of the ones I listened to recently, this one is so epic that nobody should be allowed to listen to it anywhere outside a gothic cathedral.

Spoiler: Click, click

And then there's my absolute favourite among live videos.

Spoiler: Click to see why metal crowds win

 

[Layz92]

Land of Confusion by Disturbed
Gimme' Shelter by the Rolling Stones

and quite a few others that don't come to mind right now

 

[arsenicCatnip]

Death On The Snowfield by AmIEvil, which is itself a remix of Terra's Theme from FFVI. Always fills me with a sense of awe and loss.

And You Can't Always Get What You Want by the Rolling Stones.

 

[wooty]

Gerry and the Pacemakers - You'll Never Walk Alone.

Sounds brilliant when its being sung by 40,000 other fans in the stadium.

 

[Megalodon]

One Shot at Glory-Judas Priest
http://www.youtube.com/watch?v=yX5kiemxOuE

Both of these Maiden songs
http://www.youtube.com/watch?v=dhboyKhhaCw
http://www.youtube.com/watch?v=JyYo4N2tGCE

The best of the lot, by Mastodon
http://www.youtube.com/watch?v=labytsb3gfI

 

[Guffe]

Not my favorite song but the best song to get one in a really really good mood (especially if working out at the same time) is Breaking the Silence by Queensryche

 

[Optimus Hagrid]

I save this song for when I am down. It never fails to pick me up.

 

[TheRightToArmBears]

Thin Lizzy- Emerald.
Awesome!!!

 

[ViolentlyHappy91]

The Beards, everything by The Beards are awesome.
http://www.youtube.com/watch?v=RmFnarFSj_U
It's Australian, so you know it's awesome.

 

[Totenkopf]

Well, I suppose this one has that kind of affect...

Spoiler

I just love that song. I've put it on the cd that should play when my alarm-clock sounds...

OT:
Two words for you:
Ghost Division

Spoiler: Sabaton - Ghost Division

 

[Pegghead]

It may have already been mentioned (But I think they're thinking of the metallica version and the person [Stone Wera] didn't include a video) but my favourite song in a film that plays over my favourite scene in a film in my favourite film is this


The marvellous score "Ecstasy of gold" by Ennio Morricone, it it so freaking cool.

 

[Tycho Anomaly]

Half of the 'Lungs' album by Florence and the Machine.

Adagio for Strings, by Samuel Barber.

 

[Offworlder_v1legacy]

Wish You Where Here-Pink Floyd

Tired Of Sex-Weezer

Arials-System of a Down

I have heaps of songs that I can't stop listening to. I have quite an obsessive personality.

 

[Stein Inge]

Closing Time - Leonard Cohen (For the lyrics. The music is so-so at best, but the lyrics man!)

http://www.youtube.com/watch?v=k5f6j02zHW8

She Caught The Katy - Blues Brothers (Walk down the street with this one playing in your ear and you´ll see what I mean.)

http://www.youtube.com/watch?v=9hB3eCv_FOk

There She Goes My Beautiful World - Nick Cave and The Bad Seeds

http://www.youtube.com/watch?v=TTOgUlhd_qk

Ballad Of A Thin Man - Bob Dylan (The clip is from I´m Not There.)

http://www.youtube.com/watch?v=U_qxlL9Y5iM

Lucinda / Ain´t Going Down - Tom Waits. From the "Glitter and Doom" album.

http://www.youtube.com/watch?v=lN6TJ9Jm6K4

 

[The Infinite]

Hmm lots I can think of, but as of right now...

Spoiler: Void Malign - Grendel

Spoiler: Harder Better Faster Stronger/Around the World - Daft Punk

Spoiler: Retribution - The Berzerker

Last one is just like. Damn pure aggression on a point stick. But the others just I dunno are awesome sauce.

 

[SL33TBL1ND]

http://www.youtube.com/watch?v=iHNSKhjLJ5k&feature=related
BEST SONG EVER

 

[Angerwing]

Spoiler: Andrea fucking Bocelli. Bringing the class.

 

[dragonslayer32]

any song by rise against and you run away by bare naked ladies. those songs are awsome!

 

[gjendemsjo]

Suicide Mission - Mass effect 2

It's incredible!