In games like MW2 i dont mind the odd sniper but its so easy to snipe in games now like if the first shot doesnt kill them use the whole clip!Case and point the M21 in MW2 .... but when everyone goes Sniper on a map like wasteland nothing gets done. Now im not saying the whole "Snipers are bad!" because i was always playing sniper on BF2 when playing with the clan.
From what i'v seen over the years theres two types of snipers, The douche lone wolf kind that are only in the game for their KD ratio and the Team player Sniper (a rare thing now in games), now before someone says "team player??? snipers are not team players" IF people are talking to each other (BF2 for example) it can help turn the tide of a game, sure they camp on a ridge hidden but the team players call out what they see/What they dont or can't kill.
But maybe i was just lucky with my exp on BF2

The nearest console case of teamwork snipers has to be MAG, then again that game demands teamwork.