Any caliber reasonable for self defense will overpenetrate through all walls of your home at lethal velocities. .380, 9mm, .45, 5.56, 12 ga buckshot, if you miss your target it will overpenetrate. Drywall has about as much bullet resistance as paper. The only way to prevent any over penetration is firing hollow point ammunition at your target and not missing.