I have to have multiple pistols. Otherwise I'm compromising performance. It depends how good you want to be. Nothing is perfect all the time.
-day time and night time sights. Heck, I have pistols with dawn and dusk sights as well. To have perfect sights all the time, I'd have to switch pistols 4 times a day.
-attire, weather. Winter carry is different than summer carry.
-the job at hand. Camping/kayaking carry is going to be different than going to Gotham city. A night out is going to require different choices than a weekend on the road.
My Glock 23 is my favorite overall day pistol so far. Comp sights. FO front, plain rear. I'll be making a nightime based one as well out of a G27. It does anything as well as any of my other pistols. Just sucks to reholster and handle. Safety and adaptability is a concern. When it comes out, it ain't going back in.
My Dan Wesson Valor 1911 is my favorite daytime fullsize. Fixed comp sights like the Glock. The weight helps it shoot true. It's also my safest pistol. The 1911 has it's place still. It's not too heavy at all. Get better belts and holsters. I don't wear it to the beach obviously. Around the yard, or anywhere my rifle goes. Still a good carry in the winter and where max concealment is not a worry. My preferred home d and bug out, still. Best trigger of all time still counts for much IMO.
Dan Wesson CCO/ECO. Smaller 1911's setup for night use. Once again, safety is a concern. The 1911, cocked and locked is my safest form of carry, sometimes I'll grab these based on that fact alone. These are useful everywhere, and setup to be more well rounded than my others. Giving up a hair of sighted performance, to have slower night sights.
My deep concealment Kahr p380, Keltec P32, P380 etc. etc........are knifes. Mouseguns don't count as "bringing a gun, to a gun fight". Pathetic shoot ability with these. Anything under 3" and 9mm is what I consider unarmed. It's better than nothing, but it's a patheticly useless firearm in my experience. And are they effectively accurate enough to use in an urban environment? Nope, not really.
The deep concealment pistols and J frames, just tested poorly in my hands. Yeah, they're guns. Yeah, they might work against thugs, knifes, and hardly armed gangs of cowards and idiots. But I'm dead as a duck, in a real gun fight with one. Use the last round in a J frame for myself.