Some good one's mentioned so far.
Chinatown
Texas Chainsaw Massacre (kind of, the 'bad guys' fail too but it's a nice no one wins situation)
Cabin in the Woods
Skyfall (think about it those of you who've seen it, the bad guy being beat and the good guy failing are not one and the same.)
Knowing
After.Life (wonderfully misanthropic Liam Neeson-ness)
The Dark Knight (obviously)
Resident Evil Afterlife (sort of?)
Night of the Living Dead
I could probably think of more.