Usually I loathe the sniper rifle, because A- I can never seem to get a head shot, B- because I never seem to be able to stay in any decent sniping position for more than five seconds before I get snuck up on or counter-sniped, and C- because no one else seems to have these problems when it comes to using it against me.
But for some reason I really like the Longshot from the Gears of War series. Part of it's because I can nail the active reload and get another shot ready quickly, with greater damage, and with great reliability (even when the perfect zone shrinks after multiple successful reloads). Part of it's because I can actually get into cover quickly if anyone else starts shooting (just releasing the Left trigger when the bullets start to fly). And yes, part of it is that I just really like the red fountain that replaces my enemies' recently pinged head. But beyond all that, I just have fun using it, and can put up decent sniper sprees while in possession of one. This is a mystery to me, someone who has yet to get any respectable sniper kills or sniping combos in any other game.