I am no expert, but here is my reasoning for suggesting a small handgun:
You got me thinking. A bigger size version of the same gun might have less recoil (because of the added mass) and would likely have more bullets. So you do have a really good point!