You should definitely check out the STALKER games then. Also, the original FEAR should run well on your system, it has a immersive story, atmosphere, and gunplay but lacks stealth.
The Bioshock games are also worth looking into. Especially if you liked System Shock 2.
Aliens versus predator classic and its sequel are worth checking out. I think that the latter is abandonware and you will need some tweaking to get it to run on your windows 10 system. Both games have a fantastic atmosphere and stealth elements.
I also think that Manhunt does not get enough love. Then there's Chronicles of Riddick: Assault on Dark Athena.
Also, if you haven't played classics like Thief, MGS, System Shock 2, or Deus Ex then they are definitely worth checking out.
Personally, I love Vampire The Masquerade: Bloodlines but it may not be for everyone.
I'd also second the recommendation for Clive Barker's Undying. It's a fantastic game with great level design and very good storytelling.