Sniper: Ghost Warrior by citysoft (with GW2 coming sometime this year)
Snipers Elite (as mozart mentioned, recently released on Steam)
There was one more sniper series game, I cannot recall the name right now
I think sniper elite and Sniper ghost warrior is best.
Terrific, I'll try them out.
As these guys are saying- Sniper Elite V2 came out the last couple of days. It's in WWII, but has some sweet bullet cam views and shows the gruesome damage the enemies take. Yon get the 1st one for $10 or less, but it won't run on newer OS's. I haven't played either one of these- just read up on them.
Sniper Ghost Warrior is set in modern day times. It also has cool bullet cam views. It has pretty damn good graphics and can be had for $20 or less these days. I bought it Day One- hope that helps some.
Thanks, I'll probably stick to V2, as I'm running Win7. I hope there is no significant story that I'll miss out on