Most atmospheric game

MGS2

The Last of Us, TES III: Morrowind (and the whole series in general). If so, right off the bat.

Stalker all parts and mods

Red dead redemption, Batman Arkham Asylum

Dead Space.

Metroid prime

from the latter - Bloodborne

Black & white 2.

Silent Hill 2

the call of cthulhu still

Well, there is nowhere without Resident Evil and Resident Evil 2. 

From the latest Bloodborne and Dishonored 2

Gothic 1-2, Mafia, Vice City, San Andreas, Mark Ecko's Getting Up, True Crime New York, Scarface, Red Dead Redemption, Sleeping Dogs, Vampire: The Masquerade - Bloodlines, GTA V.

The first thing that surfaced. These games are really worth playing just for the atmosphere.

Once again, I would like to mark the Souls series with the "most" stamp. One could still remember enough games, but Souls ...
 

LIMBO, Stalker, SOMA, The Witcher, Portal, HL, Metro, Deus Ex ... Skyrim 

The GUN, Call of Juarez

Peter jackson's king kong

Life is Strange, Mafia

Vice City, Stranglehold

NFS Most Wanted 2005

Chaos Theory, Double Agent

Xenus: Boiling Point

Vampire, The Darkness

Blitzkrieg, Syberia

Fahrenheit

Call of cthulhu

I also agree with all of the above 

Gulman and Gulman 2, they put so much soul into these games that they literally take you to the next world

Cho first came to mind: Dead Space 2, Mass Effect 2, Prince of Persia Warrior Within. In general, sequels are, by and large, cool.

GTA Vasya City, definitely

stalker

Bioshock, bioshock infinity