Hmm, good question and some great songs mentioned already!
For me 2 that immediately come to mind are Comfortably Numb by Pink Floyd, the song and Gilmour's solo's still give me goosebumps. Secondly would be Nutshell by Alice In Chains, a hauntingly beautiful song, if you haven't heard it yet...