For a WoY song, don't see how you could go wrong with "The Ghost of Summer's Past". It's depressing, but uplifting somehow at the same time.
From others, "...And the Great Cold Death of the Earth" from Agalloch would be good...as well as the mentioned "A Desolation Song". From Opeth, "In My...