I'm thinking in terms of unintended or accidental discharge e.g. the hammer catching on clothing, dropping, forgetting which cylinder has a live round, kids pulling the trigger etc. And what is the lightest, most comfortable CCW revolver out there?
Im going to open by addressing quality of design, which differs a little from an arms overall quality.
If you look at the good old Colt peacemaker. it is advised not to carry this gun with a round under the hammer. They ad to start somewhere in the development process and overlooked a few real world issues. As a result it is prone to discharge if dropped.
Mind you, for its period in history, there was no revolver finer.
From that point forward Colt, S&W and others did a lot of revision to address this and most arms of quality may, and should be carried with all chambers loaded. No one ever wanted a smaller capacity or a lesser caliber in a gunfight.
as for autos ... these too should be carried with a live round chambered. You only think you'll have time and ability to rack the slide in a gunfight.
In either case you will want a handgun of quality, whose mechanics you understand.
As for a kid pulling the trigger ... you bet it'll discharge. a gun that wouldn't do so is entirely useless. Avoiding this requires some thought into your own protocol with any gun.
lightest, smallest, and most comfortable really should not be at the top of the priority list.
Power and accuracy come first, and concessions are made thereafter toward acceptable levels of weight and comfort.
The last thing you need is a painful to shoot gun that groups over a foot at contact distance.