Here’s some info on choosing the right ammo for the right purpose:
https://www.usconcealedcarry.com/blog/defense-training-range-ammo-choosing-right-ammo-needs/
Also, check out this thread that might be helpful as well: Home defense: Risk of Overpenetration