Hmmm... atmosphere and story wise I like Bioshock 1 the best. But the problem with that game was that there was no real penalty for death, so you were free to just charge in whacking things with a wrench till they died. Infinite made an actual penalty for death. Minor really, but enough to make you care about surviving.
Never played any of the System shock games.