I think this thread needs not only TW but spoiler alert too.
The ones that come to my mind are:
Johnny cash - hurt - in person of interest when John goes on the rampage after joss' death - cannot watch that and keep a dry eye
Bones - placebo - running up that hill - bones' dad takes his revenge against those who caused he & his wife to have to go on the run abandoning bones and her brother and ultimately resulting in his wife's murder
Greys anatomy - I've not seen the whole series but watched first couple seasons when it first came out and STILL Remember
Snow patrol - chasing cars - Denny's death
Charmed - so many great show for music but particularly:
Angels - Jane Siberry when Andy dies
I miss you - Stevie nicks - prue's funeral
Michelle branch - goodbye to you - coles final exit in centennial charmed
Agree with several pps too, desperate housewives, mamma mia,