I knew there was one I was forgetting: Condemned 2: Bloodshot.
In the effort to combat an impossibly unconquerable hangover, I recently threw in the original Condemned for old times' sake. The original certainly nailed the horror atmosphere: the right balance of realism and a bit of curious supernatural smattering. You really felt like a naive yet hardened cop in a Max Payne world, but the drugs were truly rotting the people, body and soul.
The second completely ruined this atmosphere, though it did nail the combat control. That said, the plot of 2 is so confused and lazy that I treat the games as separate universes. Nice to make heads explode with your mind, though (finally, the fifth Wude).