Well, I doubt I'll ever have a suicide mission or inner city riot directed my way, nor will the "little black helicopters from the UN" be forthcoming, so .....
1. old 22cal Ruger, for fun, and it's by far my favorite
2. PPK Walther (380) in the glove compartment of my pickup, and a SW "detective special" 38 snub nose in the car
3. 357 SW "california highway patrol", basically a lighter weight revolver, for finishing off a wounded deer (rifle hunting is not the issue, but this dog hunting stuff with shotguns doesn't always result in a clean kill), zapping snakes when hunting, etc
4. 40 cal Glock and 9mm Glock for no good reason - basically, a mistake, as I've no real use for them
When I showed up in Alaska to fly fish my first (of many) trips from 1980 through the present, they - the folks at the largest fly fishing shop in Anchorage - politely but firmly recommended I not shoot at a bear with my 357, or a 44, or anything short of a shotgun. Why, well the ballistics are obvious, but also folks tired after a long day slogging along streams working trout and then surprised by a large critter tend to NOT be as accurate as they might be on a shooting range, and it takes some pretty good shots to bring down a larger bear. So, the fly fishing guides I worked with carried a pump (ALWAYS WORKS, and is attached to the backpack most guides carry for gearing up clients) 12gauge with 3 or 3.5 inch chambers, 00 buck and a 5-7 shell magazine -- or a recommendation to spray a small fire extinguisher sized combo of mace and pepper powder at the bear, and back away. A pistol - sure - best of luck.
Oh yeah, the country home defense weapon is not a pistol, but a 10 gauge double barrelled "coach gun" (18 inch barrels, small stock) - sure, I've lots of other weapons around, as do most folks answering this thread, but in close quarters......