I have fired about 6 different handguns over the past few months. The first was a Walther P22 and it sucked. It was too small in my hand and I could not hit anything. I also fired a 40 caliber Glock the same day and felt overwhelmed by the power.
Next it was a 22 revolver, 38 revolver, 9 mm Glock, and also a big boy gun but I can't remember the caliber. Maybe a 45?
By comparison, I also fired a pair of 22lr and 9mm rifles, and hit bullseyes easily. But everyone keeps telling me the 22 isn't good enough to stop an attacker. So then I finally fired a shotgun and found I could hit the clay pigeon sometimes and the kick wasn't bad at all. It seems like the logical choice for a weapon with knock down power and fairly easy to aim.
In all I just don't feel confident I could hit a target under stressful conditions with a handgun, and a story from my initial instructor stays with me. An LE and expert marksman at a range he knows got caught in a firefight, and the guy could not hit his target at all even after 40-something rounds. Having someone shoot at HIM changed the whole situation. I don't imagine I would fair much better even with lots of practice.