For me i found Far Cry 2 spectacular, probably the best first-person shooter of all time, because it constantly makes you feel like shit about the fact you are playing a mass-murderer. That felt confronting and "real" to me. Another game that does this is Spec Ops: The Line, although that is a much more tightly-plotted "interactive movie" type game where you are funneled along certain paths to advance the story.
Another very bleak and depressing shooter is Metro 2033. It is horrendously difficult. You will never have enough ammo. Your gas mask will always break. I never finished it because it made me feel too miserable every time i played. Unlike Far Cry 2 you are forced down corridors, so there is no respite. You can't just go out in the jungle and watch the sunset for a while.
If you are looking more for "open world" games where you can wander around on a big map and do your own thing, there are dozens of those. Personally i am not a fan so i can't give a specific recommendation, but you could check out any of the other Far Cry games, the Assassin's Creed games, Grand Theft Auto 3 and later, Fallout 3 and later, Red Dead Redemption, Stalker series, Metal Gear Solid 5 and probably the other ones too, etc.
If you are more interested by the sickness and vulnerability aspect, there is a whole class of games called "survival games" that don't give you a storyline, they just set up random environments that you have to walk around and survive in. I imagine the better ones are similar to those times in Far Cry 2 where you crawl on your belly through the mud and the elephant grass desperately trying to make your way to the doctor who will refill your meds before you die of malaria.
It really depends what you are looking for from a computer game. Personally, i get Far Cry 2 feelings mostly from games that don't follow shooter mechanics - walking sims, art games and adventures... but those genres are frequently likened to "interactive movies", so i think it depends a lot on your taste.