"Watching Over Me" by Iced Earth popped in my head immediatley. It is a really beautiful song, Jon Schaffer wrote it about his friend who died in a motorcycle accident.

http://youtube.com/watch?v=WUqK50hEQlA

I'll go through my Ipod and find a few more good ones.

Edit: "Cemetary Gates" by Pantera is another great one.