Interesting question. For me, it really depends on the gun and purpose. My defensive guns are very rarely fired SA, and in fact most of them are DAO - either bought that way or made so after the fact. I can see cocking the piece for a 50 yard shot at a rifle-wielding madman, but otherwise, I just don't see a reason for SA defensive shooting.
The huge majority of my shooting is purely for sport, though. I enjoy trying to clean a rack of plates at warp speed, or dumping a cylinder and a speed load into a big target close up, and of course a light, smooth DA trigger is just the ticket for that game. I also enjoy a bit of artillery practice, trying to drop a bullet into a ridiculously distant target, and a perfect SA pull is the obvious answer there.
I'm not sure I've ever taken a DA shot at a game animal. There was a pig I gut shot, as a very young and inexperienced fellow, and I emptied the gun at him as he ran. I was so excited that I honestly have no idea if those shots were DA or SA.
Purely in time spent, I'd say I'm probably 50/50 DA/SA in the sporting field, and roughly 99.9% DA while "training". In terms of rounds expended, though, it's be essentially 100% DA for defensive practice, and probably 80% DA for fun.