FWIW, I have assorted 45s, 9mms, 357s, etc etc. What I usually grab on the way out the door to go to the grocery is the S&W Mdl 36.
I am now officially a sillyvillyun, and do not chase bad people for a living. My sidearm is for my defense. It is small enough to conceal readily, light enough that carrying it is not a burden, and has enough stopping power to give me room to run. In a snubby, I can put 5 rounds in a bad guy at point blank range while the .357 shooter is trying to get back on target for the second shot. There IS that pesky recoil thing with miniature handguns.
Are there times that my sidearm of choice is a caliber with more authority? Yep. Autoloader? Yep. But the thing that attracts me to the double action revolver is simplicity under stress. There is no question as to whether the mag is fully seated, did the slide go fully into battery, did I get the safety off, did I limp wrist the gun- pull trigger hard, loud noise proceeds from the hole in the front. If it does not, repeat step 1 and pull trigger hard.
Your mileage may vary, void where prohibited or taxed, in hoc signo vinces (you're in hock to Signor Vince)