Whiter Shade of Pale - Procol Harem
Tongue - REM
Neon Moon - Brooks & Dunn
Fell On Black Days - Soundgarden
People Get Ready - Rod Stewart & Jeff Beck
Tammy's in Love - Debbie Reynolds. No, I am not joking
One - Metallica
God Only Knows - Beach Boys (at least until HBO's "Big Love" started using it)
The Warmth of the Sun - Beach Boys
Don't Worry Baby - Beach Boys
Harbor Lights - Boz Scaggs
Theme from "Valley of the Dolls" - Dionne Warwick
You're Still the One - Shania Twain
Sunrise, Sunset - Soundtrack to 'Fiddler on the Roof' (for Old Dude

)
Black - Pearl Jam
Lightning Crashes - Live
Invisible Sun - The Police
The Ecology - Marvin Gaye
Miami My Amy - The late (and very great) Keith Whitley
Secret Love - Doris Day No, I am NOT joking. And stop asking me that.
Fly to the Angels - Slaughter
Woman in Chains - Tears for Fears
Dreams (I'll Never See) - ORIGINAL by Allman Brothers. Molly Hatchet's cover is awesome, too
Hunger Strike - Temple of the Dog
* The Rain Song - Led Zeppelin
* One - U2
* Like Woody Allen and David Mamet movies, U2 and Led Zeppelin are excluded from my rankings. There are too many great ones to compare them - and they would exclude others that belong there. So just ONE EACH from Zeppelin and U2.