Single-actions can be just as deadly as double-actions, but there are so many problems associated with them that I higly recommend against using single-actions.
For home use, okay. No arguments.
For street use, if you shoot someone, it means you had to cock the hammer, and if you cocked the hammer, it's possible that you shot the person accidentally, under stress. So the incident can be open to a negligent shooting lawsuit. If it's in your home, it's too bad for the bad guy. He wasn't invited into your residence; however, if you're carrying the gun, then it's reasonable to suppose that you were expecting trouble. And in the stress of the moment, your actions can be challenged.
Massad Ayoob has written a lot on this, and he's caused a lot of people to do things like bobbing the hammers on perfectly fine double-action guns, which I feel is a mistake, especially for a gun in your dresser drawer. But for a CCW, it is a bit different.
Most people who are victimized in court are victimized for something they did or said. But again, if you have a target gun with a hair trigger in your home and an intruder enters that home, you're legally able to use any weapon at your disposal to stop him, whether it's a kitchen knife, a poker or a spade. And if you have a target pistol or single action, then so much the worse for the intruder.
So leave the single-action at home and get a good double-action revolver or auto for carrying.