Personally, it has nothing to do with the game, and little to do with the weapon. Sniping can be fun in any game, or it can get very boring. It's all about what happens before you kill the enemy.
Single handedly picking off about 80% of a team full of noobs (or people with no defense against...