Definately a game for people who love sniping!
Sniper Elite was a bit of a sleeper title that came out back in 2005. It's a bit of a rarity now, so good luck finding it anywhere but in online stores.
You play an American agent who is working for the British, near the end of World War 2. Basic point of the game, keep Russia from getting Germany's atomic bomb plans. While the game is mainly 3rd person, you do your sniping in first-person through your scope. With wind, gravity, shortness of breath and heartbeat effects, this is about as real as it could get. Headshots go to a bullet-time effect to let you watch your handywork blowing someones head off, or their eye out, or their teeth, what-have-you.
Anyhow, I'd recommend this title to people who love to snipe. The enviroment definately feels like bombed out Berlin. You can mask your shots with artillery explosions even! It has this Enemy at the Gates vibe to it aswell. Sound is very important in the game overall. So if you have a pair of good quality speakers then your all set!