If you haven't played any FPS in almost a decade -
I'd recommend Doom3 - once you get more used to playing FPSes again. Doom3 is beautiful, and highly effective in it's scare capabilities . . . but even on normal and easy, many points of each level can be insane hard to get through - especially when you've given up trying to make use of the flashlight and just start using your current weapons muzzle flash to help target your enemies.
Quake4 is worth the time to check out, though - although it's a bit more hardware intensive compared to Doom3.
Also - the Thief series, if you have a lot of patience and don't mind having to observe your enemies before you make a move. Granted, the first two are graphically showing their age . . . the gameplay, story, immersion all come together to create something that was groundbreakingly brilliant. The third installment runs off the UT2 engine, and is graphically superior, and still has a great story and gameplay - but us die hard fans weren't 100% thrilled with it.
Although . . . the mission known as "The Cradle" in Thief: Deadly Shadows is, IMO, the single most brilliant and effective mission in any FPS I've played. That mission alone was so praised, that PC Gamer published a 10 page story on that mission alone . . . the first time they've ever go so in-depth for any mission in any game to that point. Well worth the time to check out.
and speaking of the Thief series . . . RIP Looking Glass Studios
I've you're up for a little "thrills and chills" - pick up F.E.A.R. Great enemy AI, decent graphics and quite a few moments that'll keep you on the edge of your seat . . .
. . . although, not as effective your second time through