This is a list of my favorites. If there are more you would like to add, let me know. I'm sure there are many I have omitted.
If you ever have the chance, look up Ry Cooder's Feelin' Bad Blues off the Crossroads ('86) soundtrack. So beautifully sad.