if sniping was a factor, then why send a stealth agent? You should send a sniper. But in any case where it is a one man operation, Sam should replace him pistol with a MP-7 its a pistol, sub machienegun and a small sniper rifle, and still has strong rounds.
http://www.hkpro.com/pdw.htm