If this is just home defense, why not a rifle? Something like a Ruger 10/22 would be perfect. No need to stick with a handgun unless it’s going to be concealed. There is literally zero recoil, and it’s not super loud. Even less if you throw a can on it. A red dot, flashlight, and rim fire can would make it pretty much perfect. A BX-25 magazine full of CCI Mini Mags should get the job done.