I think the mod I used for Stalker was the Complete Mod. Which, as the name suggests, is quite ... exhaustive. You could try look that up, if you haven't already. I don't normally mod my games, but I can't remember having any difficulty with it.
Edit: L. A. Noire, for all its gameplay flaws, is really growing on me. As it gets more personal, it gets way better.
Edit2: I wouldn't know about the story, and I'm not sure I like the arcade setup, but I can say this much about FEAR3: It's a solid action game. It has cover. It has slow motion. It has fairly intelligent enemies ( they use grenades to flush you out if you're in cover and if you're not being aggressive enough they come for you. I've yet to see them try to flank me, but I've really been too busy killing them to notice ). And even the scripted moments in CoD have a hard time beating the sheer awesomeness of running across a slum street in slow motion, shooting a guy in cover, entering the building at the opposite side of the street, rushing through it to a window to pop the next guy, who thinks you're still somewhere up ahead.
Actually, they definitely do try to flank you in open spaces. This really is a game that punishes you for camping, and encourages you to flank your enemies.
Also, what's worse than zombies? Zombies with weapons? Zombies on fire? Try zombies with explosives strapped to their chests. You will learn to fear the sound of beeps that draw closer and closer.