I enjoy sniping, particularly on BFBC2, because especially in that game it does actually require a modicum of skill to pull off that 300+ markman shot on the poor pleb 3km's away. Adjusting for target movement, projectile drop over distance, leading the target as they run, and combining all that to pull off a perfect headshot, gives one of the most satisfying feelings in first person shooter gaming.
Sniping in Modern Warfare though, is a whole different kind of challenge; a challenge to stay alive. Because of killcams, any person you kill with your magic boomstick which hits instantly, terminally and 100% accuratly, knows exactly where your scraggy arse is, so the challenge is to find the balance between a good hiding position, a healthy ammount of kills, and the ability to move from place to place without being seen, heard, and more importantly killed...
My very first nuke in MW2 was with my trusty Intervention on Wasteland, Hardcore Headquaters, from using that very same tactic set, and believe me, no other way feel quite as satisfying.