Neil Young's "Captain Kennedy" from his album "Hawks and Doves" is one of my favorites.

I have been told that the melody was taken from an old English folk song but I have only someone else's word on that.