I have several of the guns that have been discussed. First the Smith 3rd generation. Out of production, but excellent guns. I have the 6906, compact, stainless with the 12 round magazines. It can also use the 14/15 rounders of the 5906 and I have several with adapter base pads, to allow it to conform to the shorter grip length of the 6906. It is DA/SA. The 6906 in stock configuration has no spur on the hammer, so you can't cock it manually. I changed mine to have a 5906 hammer which has the spur, and I like it a lot that way, as you can cock it for SA if you want, like most revolvers. Or you could just get the 5906. You normally would have the first round DA and then it is SA. Or you can cock it manually. I am fine with that, but it is not like a revolver that way, if you were firing only DA. Although there are DAO versions of the Smiths. You should find one and handle it. You can put your thumb on the hammer when re-holstering. If the hammer is back, like firing in SA, you need to drop the safety before re-holstering. Check them out. There are a gazillion of them out there, and they are generally cheap compared to other guns. And there are dozens of different models/varieties. But they are great guns.
Then I have the Glock 26. I love the gun, but no way is this a revolver. It is the classic striker fired pistol. Ultimate in reliability, and accurate. I have a light trigger on it, so I won't carry it with a round in the chamber. Too many instances of negligent discharges in my view. You can get the heavier "New York" trigger, but I have no experience with it. And you can't put your thumb on the hammer when re-holstering, although there is that extra aftermarket safety you can install which allows you to put your thumb on the back like it was a hammer.
Another gun that I have is the Sig P290RS. Out of production now, definitely DAO like a revolver with an exposed hammer. You can put your thumb on the hammer when re-holstering, and I do that with it. The problem you might have with it is that it is normally 6+1 capacity, although it also has an 8+1, with an extended magazine. But I really like the gun. It is solid, and has been reliable and accurate. And it really works like a revolver. DAO with restrike. It is heavy like a revolver, but feels good. A good pocket gun. And you can get them cheap, as they have been replaced by the Sig P365. Which brings me to my last one.
The Sig P365. I know it doesn't meet your DAO requirements. It is striker fired. And it has a light trigger. But it holds 10+1, and possible 12+1 or 15+1 with larger magazines. I don't like the risk that comes with that light trigger, like on my Glock 26. But I feel I can carry it safely, as I got the manual safety version. I carry it often. I really like it and feel safe with it. I carry it AIWB, but it can be pocket carried. But you would need to adjust to operating the manual safety. That replaces the "having to put your thumb on the hammer" business. I have used safeties often and am comfortable with them. It shoots really well. Feels good in my hand.
So good luck in your search. I also have several revolvers, and my favorite is a DAO. It is actually my favorite gun of all, and I do carry it sometimes. There is just something about a good revolver.