R.C., you have damn good tastes!
As for me, I don't want to list too many that 38834 people already said. Some are sad for personal reasons, but anyway :
Too many by Porcupine Tree to name
Pearl Jam - "Black", "Light Years", "Slight Of Hand"
Deftones - "Teenager"
A Perfect Circle - Although the entire album hits me hard, "Rose", because I always question my ability to fight back...
Acid Bath - "Scream Of The Butterfly"
A.F.I. (Shut up, I know it's punk.) - The Dispair Factor
Anathema - "One Last Goodbye", "Fragile Dreams"
CKy - "Sarah's Mask"
Dark Tranquillity - "Hours Passed In Exile", 'Lethe"
David Bowie - "Space Oddity"
Foo Fighters - "Hey, Johnny Park", "Tired Of You"
Katatonia - "Sweet Nurse", "Help Me Disappear"
Lilitu - "Autumn Leaves"
Maudlin Of The Well - "Geography"
My Dying Bride - "For My Fallen Angel"
Nine Inch Nails - "Hurt"
Our Lady Peace - "In Repair"
Radiohead - "How To Disappear Completly", "Lucky"
Rapture - "Enveloped"
Silverchair - "Miss You Love", "Too Much Of Not Enough"
Smashing Pumpkins - (way too many to name) "Thirty Three", "Disarm", "To Forgive"
Stone Temple Pilots - "Interstate Love Song", "Big Empty"
Tool - "H.", "Pushit", "Disposition"
Tori Amos - "Winter", "Me And A Gun", "Precious Things", "Bells For Her", "Past The Mission"
Aaaaand endless others.