I am assuming a little, but it is interesting to me that folks in this conversation are divided between heavy caliber (and recoil) like 10mm and .357 (and possibly hot loaded 45 ACP).....and uber manageable recoil like a 9 mm service pistol. I think those same folks are also divided between more urban vs more rural scenarios.
I know that my carry choice goes from 45 ACP (most of the time, always if I'm in town) to 10 mm (winter, in the sticks where my home is) based on where I am.
It is highly unlikely to need a longer range handgun in town. My rifle is in the truck if I need that. On the other hand, in the sticks, I could absolutely find myself away from my truck, and needing to shoot something out to 50 yards.
Noting others in this conversation....I have never been shot at. BUT...I have used my carry gun many times on critters, mostly coyotes or a car struck deer.