Today, I finished the season 1 DVD set of Everwood. I poked through its soundtrack CD on iTMS a while ago, but nothing grabbed me, not even its covers of old Cat Stevens tunes. The S1 finale, "Home" features Jump Little Children's "Cathedrals" over its end. And I had the same reaction as with "Brothers In Arms". By themselves, nothing. In context, something akin to magic.
Of course, it probably says something morbidly odd about me that these songs are both associated with scenes involving a character's death. *shrug*