It depends on the Game really how much Fun i would have with a Sniper.
For example, this little game called Black Hawk Down, which is basicly another Delta Force Installment from Novalogic had a great Way to actually be a sniper, although it was challenging to try. You had basicly two Options, either you camp on a Roof, snipe down into the Streets but risk being either "backstabbed" or simply shot down, because your Range is still within their Range as well. Of course changing Position to another is fairly easy and you have Cover most of the Time.
The Second Option is, going very far out, and i mean, like 800 Meters or more from the Center of the Map. Depending on the Map this is good and bad. You cant snipe into the "Town" for example if there are alot of Buildings, so you are forced to pick off anyone you can see from whereever you sat down. Changing Positions takes time, indeed even getting that far out, on foot i might add, takes at least about 5-8 Minutes from the start of the Game. a Round has a limit of 30 Minutes. So moving from one side of the "Town" to the other takes about 10 Minutes again, because you have to Circle a lot of Distance. On the plus Side, if you are good with your Sniper, you manage to hit a moving Target 800 Meters and more away from you with one Shot, you have to factor in that the Bullet needs to travel to them, so just "pointing" on the Enemy makes you miss unless they stand perfectly still from the Moment you pull the Trigger and the Bullet hits the Target, which is about 1-3 Seconds. Therefore when they are moving you have to "hold ahead" their Way to hit them in which they can also simply change Direction by a few Steps, making you miss. It is however interesting in terms of Sniper vs Sniper, when you basicly looking at every Hill and such for that black little Spot, which is the Head of another Sniper. Usually also at least 500 Meters away from whereever you are.
In Combat Arms though it is also Fun, though mainly i play No-Scope. I can Quick-scope, i can also Scope and Wait for a good Shot, but when it comes to close Combat, which especially in Sniper Only Games is fun, then No-Scoping the other Guy is incredibly fun, especially since you have no Cross Hair at all telling you how much your next shot might spread.
So yes, depends on the Game and to a degree the Player, but a Camper will always camp, no matter which Weapon he has. And a sniper rifle is for me a prefered Method opposed to using a Grenade or Rocket Launcher.