I enjoy sniping, tend to play a reasonably team orientated sniper (and was team sniper in a COD4 tournament because of it), in that I will usually try and weaken regions to help my team, even if I am off lone-wolfing around the map. Can make a big difference in defence or when your guys are attacking if defenders are keeling over or suddenly losing half+ health.
Like mentioned previously, you do kinda have to play the game a bit to get a feel of the sniping weapons, some games lead and some don't so you need to acclimatise to be any good.
Also, taking a few shots from one position then moving off tends to be a lot more enjoyable than just camping one spot; unless you've found the ultimate spot (and you wont be able to stay there forever either!)
Like mentioned previously, you do kinda have to play the game a bit to get a feel of the sniping weapons, some games lead and some don't so you need to acclimatise to be any good.
Also, taking a few shots from one position then moving off tends to be a lot more enjoyable than just camping one spot; unless you've found the ultimate spot (and you wont be able to stay there forever either!)