I have a .45 with "frangible" rouds I picked up at the Fort Worth gun show. The idea is to have a large cal. round with some punch, but with very limited penetration. Police departments like them for the reduced risk of through-and-through shots endangering bystanders. Air Marshals use them so they do not punch holes through the fuselauge (how do you spell that?). They are good in the home because you will have a round that discenegrates when it goes into the sheetrock. It may blow a hole through the wall, but the fragments are too small to cause great harm and have lost most of their inertia.
What people tell you is right about .22s. You have to place the shot very well to be imediatly effective. While your burgler or assailant may not drop to the floor from a .22 shot, he might just as well die in three hours from internal bleding...but you are already a victum by then.
Shotguns are big and bulky. They are also devistating weapons. The unmistakable sound of a pump action racking a round into the tube WILL imeadiatly turn your bad guy around every time. If you do not NEED a handgun, do the "low brass bird shot" thing in a 12 gauge.
Alright people, pay attention:
"To Many " is an address like in a toast or tribute while "Too Many " is an implication of excess.
I think I am the only non-fox guy out here!