As OldCop and others have said, it makes absolute sense to carry the same or similar gun to that which you carry on duty. It would be a shame to waste all the muscle memory & confidence you develop with your duty weapon!
I've tried a number of autos and found the ones I chose too bulky for me (Beretta Px4); bulky and not fully reliable (Beretta 84); and a variety of classic pocket autos. The only one of the latter I've found reliable is a Remington 51 in .380, but occasionally even it has hung up due to ammo, aftermarket magazine, or whatever. Not a great feeling with either reliability or power level, but rates occasional carry when its flatness seems indispensable.
I've standardized on S&W revolvers and am trying out a couple of Charters, since their cylinder release works like S&W's & in most CCW respects they're functionally interchangeable. (True, cylinder rotation is opposite direction, which could be a problem in a partial reload situation.)
Bedside, I have an S&W N-frame and a 1911 that it took me 500+ rounds to break in fully and make it reliable--at least with one specific load

The N-frame is my "go check the noise" gun; the 1911 is the "lock & load, they're coming!" gun. Familiarity through service use and recent/ongoing practice with this 1911 example leads me to accept the tradeoff in slightly reduced muscle memory in exchange for firepower & rapid/handy reloads.
If I were an LEO with the duty to confront, pursue, and capture, I would want an auto for service and concealed use, just like the OP. As a civilian now, the lower firepower of the revolver seems adequate for my needs.