Pistols in Call of Duty aren't bad... well, I haven't played BlOps, but in the Modern Warfares they're definitely powerful enough to not be useless. Especially in Modern Warfare 2 - Akimbo G18s anyone? Hell, even a single G18 was worthwhile. And don't get me started on the Raffica... why Infinity Ward thinks 3-shot burst weapons must be overpowered I'll never know.
And even if you're just talking about the M9, USP .45, and M1911, they still definitely weren't worthless (as I'd regularly score multiple kills at once with them)... they just weren't as powerful as primary weapons. Which is a good thing.
What's forcing you guys to only pre-order from Gamestop?