yea that sounds like a great idea just go outside and shoot people
but in any case in terms of sniping itself I don't know any games beyond the sniper elites that actually make snipers its primary focus
they are other games involved with stealth killing and I guess strategic placement, theres far cry 3 (ish), metro 2033/ metro last light, and anything else that may fit in that genre although those games are pretty far apart any game that has silencers, stealth and actually thinks its a good idea you may be able to create a similar experience
unfortunately these games do not have a similar multiplayer so technically no your kinda of out of luck (they only thing i may think of is when RDR was still popular and you can shoot guys 2 miles away)
Ah, and for future games (sorry I keep rereading your post and it almost feels like you're adding crap right as I turn away) maybe Metro Last light but there multiplayer isnt coming out for another year, or at least thats what they say.
I don't think there are any sniper only games for MP. The only ones I know of are the 3 you listed. Could always find a sniper only server on CSS only game I know that has very good sniping. Other then that COD 4 is still a good sniping game and easy to find sniper only servers.