Get a .357 revolver, and then some type of semiauto .45 and small carry type .380/9mm.
Ruger SP101- .357 revolver- You can buy less expensive .38 Spcl ammo for it. Buy American. Ruger/ S&Wesson etc. Buy Federal Ammo made in America. Buy Buy Buy!
May I disagree with your .357 Mag recommendation? Ok for an experienced shooter who can hit the bullseye - but not good for an inexperienced shooter - even a lot of experienced shooters have a problem with the recoil and/or expectation of it.
And a .357 Mag is a terrible weapon for home defense - after dark. The flash will blind a shooter for 4 seconds or more - something you can afford if someone is in your house.
Love my S&W Pro-Series 686-6 in stainless w/5” barrel & 7 round cylinder, but it won’t be pulled after dark.....Oh - forgot.....lost it when the canoe flipped a year ago........