The House Of Flying Daggers sees the main dude die at the end, if I recall correctly.
Also, The Butterfly Effect (although I have seen a different ending on TV that was happy so I don't think he died in that)
I can't believe you've watched those. I'd rather watch "Weasels Rip My Flesh".