I bought Glasser cartridges for all the hand guns we use for home protection. They won't pass through a person or a wall. With the shotguns we use light skeet loads.
When the wife shot the intruder a few years ago most of the pellets bounced off the kitchen counter. She was using real light Grouse loads, with #7 shot. The Doctor that removed the pellets from the intruder said they had only gone in an inch or so in the unprotected areas. His clothing stopped most but not all of the pellets. He was wearing jeans, and a lined denim jacket. Fear kept him running when he left. Infection is what got him to the hospital.
I went on many calls at Ft WW where guns had been discharged in Post Housing. Bullets were in most cases FMJs. These bullets passed through the exterior walls, then hit another house, passing through another exterior wall. The bullets were usually stopped by things like boxes of books, metal electronics cases, wooden cabinets, or furniture. Fortunately no one was hit by these wayward rounds. But the damage done showed if someone was hit they could have been killed or injured.