I pretty much never use Sniper Rifles for long-distance targets, in both Files and Piratez. For the long-range shooter and heavy shooter niches I rely on rockets and heavy automatics respectively. Rockets are very forgiving with near-misses, especially if you're shooting down onto a lower elevation using a hill, roof, hovertroop, etc and frankly they're just more fun than Big Damage Bullet. I prefer heavy automatics over snipers because they're both proficient at dealing with single-tough targets, but the multiple shots makes automatics less susceptible to missed shots, bad damage rolls and other "Target's Still Up" moments.
But that's all just me; most people took Vahlen's chiding to heart and stopped using explosives for everything because they're scared of blowing up the loot. There's tons of people who like Aimed Shot w/ Rifle as their primary xcom problem solver and Sniper Rifle is basically the final evolution of that.