Johnny Cash's "Hurt" is a great song for really torturous subject matter. I recall a pretty good Angel
video on the subject that chronicles Wesley's arc.
"Holding out for a Hero" generally yields very good videos in any fandom. I've seen quite a few good ones set to that, including a couple Doctor Who
videos (Jon Pertwee & David Tennant) and a Torchwood