STALKER series for sure, i dont know a single game that comes even close when it comes to atmosphere, maybe System Shock2 though, which i replay every now and then.. those are on the list of games which i've actually cared to play to the very end, which says a lot

Deus Ex was good, never played it to the end though, got tired before that.

Boiling Point was fun and atmospheric but not very engaging.