I think that the answer to your question depends more on the experience level of the person behind the gun than the gun itself.
If you have several people that live in the same house that have access to the gun and there experience level is limited, then a good quality revolver is the way to go.
It’s not so much the reliability factor, but the person’s ability to work the gun when they are under a very high level of stress.
That is why for me, a revolver is the more reliable gun. All you do is pull the trigger. If it fails to fire you pull it again and again.
There are no safeties to forget, no magazines to mess with, no opening the slide to see if its loaded, no condition 1, 2 or 3 (hammer back safety on) to remember or mess with, and no FF's to mess with or clear.
I carry an auto, a Glock 26.
For my wife, she carries a Smith M60 but she also knows how to use the Glock.
Pick the gun that fits your hands and experience level the best and stay out of the “Who makes the best gun” argument.