I'm just glad people are nice enough to respond and give their input. I feel like a handgun is just more practical and versatile compared to a rifle or shotgun. I can keep it in the nightstand without it being in plain sight (which is an issue for the Mrs.). I can stow it in the glove box when we go on road trips. If I really wanted to I could open-carry and take it everywhere.
As for revolver versus auto-loader, I have a Walther PPS as my current nightstand gun, but there are some things I don't like about it. My wife can't reliably shoot it, as she has a tendency to limp-wrist it. I've even done it a few times, and I want to know that the weapon won't malfunction. As for capacity, the TRR8 is 8-shot, which is one more than I have currently. I know I could get more from other auto-loaders, but that brings back the reliability issue.
I guess I'm not really looking for a weapon that is THE BEST at home defense, but rather something that is the best for me. Let me know if you have any pointers or advice.
I Gotcha. It sounds like you know what you want. Not much advice I can offer other than trying to get the wife to the range for some training to help solve the limpwristing. Or persuade her to let you stash a long gun somewhere handy. Lol. But I know how that one goes.