These days with virtually all modern pistols having a trigger block that will not allow a primer strike unless the trigger is pulled via different types of internal trigger linked safety features….
Aside from more safeties more better, with a proper holster and trigger control is there any reason not to carry a modern hammer fire DA/SA condition 0?
Generally speaking, the SA trigger pull on a DA/SA pistol when cocked is significantly lighter than on your average non-tuned striker fired pistols.
What you don't want to happen is going bang prematurely when trying to draw under stress, or by accident when holstering / unholstering.
You can see videos of folks shooting themselves in the leg drawing on the range.
Odd things happen during holstering or such.
If you have a manual safety, go ahead and carry it cocked and locked like a 1911 if you so wish.
Otherwise it would be prudent to carry it in DA mode
Something to remember is that unless it is your job to go looking for trouble, chances are you'll carry your gun your whole life and never have to use it in anger. So a bit of extra safety is a good thing because a Bang when you didn't mean to, can mess up your life big time.
In a close quarters, high stress situation, you won't even notice the DA pull and if you have enough time or distance to be worrying about a really good aimed shot, you have enough time to pull the hammer back.