UT2004 is a blast. Just got it.

*Ahem*

That being said, I view snipers as assets and those who are very good have a lot of skill indeed, this coming from my CS experience. I only ever became a slightly better than average sniper in that game, and I know what a difference a good sniper can make.