Dink's Song is a definite favorite for me. When there is a song of betrayal and/or unrequited love, I like it good and mournful. In the Pines, and Twa Sisters / The Wind and Rain are good in the same vein.

On the flip side, deception also makes for a great humorous song, like New York Girl's, Can't You Dance the Polka.