I've never held a handgun before, much less shot one (so take my opinion with a grain of salt). Based on my experience playing Counter-Strike, shooting BB guns and target rifles & 12-gauge shotguns, and in archery, I'd probably like a Desert Eagle.
But honestly, what I'd really like is a long-range scope sniper rifle. It'd rock to knock off a pop can at 1000 feet!
