IF .223 THEN frangible ammo for home defense.
ELSE your rounds can perform a full house penetration.
.22LR can also over penetrate and aint terribly lethal unless you place a lot of rounds in your target.
If you are rightfully concerned about drywall penetration, then consider getting a Remington 870 Tactical shotgun, and load it with NON-magnum 2 3/4” shells and #8 shot.
My two cents.
Please educate yourself and stop misinforming readers of this forum. Frangible bullets are designed to break up into small pieces when impacting hardened steel targets. Against soft targets like terrorists or building walls, they act just like full metal jacket bullets.
Any bullet designed to terminate a lethal threat, will easily pass through walls, aircraft hulls, etc. Use what the FBI and Secret Service uses. Hint: Gold Dot.