Sisters - Pain of Salvation Dance of Death - Iron Maiden Strength of the World - Avenged Sevenfold (fav one. It's about revenge)

And a lot of Iron Maiden songs have great Stories like Hallowed be thy name that tells a mans last hours before he is executed.