I'd lean towards the 1911 but that's to cliche. Hell, I think even my dog is building 1911s at this point

It and the Glocks are hard to beat.
I love the M9/Beretta 92 series and they've done a lot of good things even if they are 9mm but I think the F model safety is useless. The G model decocker is better. Besides since I shoot mostly Glocks I always forget to take the safety off (but don't have the same problem with the 1911

) The M11/Sig 228-9s are about the right size and capacity.
Revolvers-
I have been eyeing the Colt Detective Specials on GunBroker. Same basic size as a SW J frame with 6 rounds. To bad thier not currently in production.
The 327/TRR8 series eight shot 357s could hold thier own even against an auto if you trained with it enough.