Seeing what #8 does to 4-legged pests at close range (NOT MUCH), my HD shotgun has #4 turkey as a minimum and mostly 00 and slug on/in it.
I live in the country and need a Barrett to hit the neighbors, but my house is small enough that not even #8 would dissipate fast enough before it could find a kids' bedroom.
My answer (thanks to TBD) is to go to ground and put the misses and (hopefully) overpenetrations in the ceiling.