Maybe it's just my miniature wargaming background, but I've always thought the off-hand was the best place for a pistol. Sure there are some negative modifiers, but if you're close enough to shoot a pistol, then you're close enough to need to use a melee weapon next round.
Updated: I forgot to...