Just for myself, as a new shooter, I kind of think the DA/SA is good in the sense that it is harder to get off a first shot unless you really intend to do so. Then after that first shot, all other shots are easier with the SA. So I guess that is more err-ing on the side of safety/deliberation. You could cock the hammer first of course, just like a revolver, for the first shot.
Anyway, on the 226, I shot that a number of weeks ago as part of my self-education on all manner of firearms that I can rent and shoot. It was a great shooter.
In fact, almost all my friends who have black semi autos have the Sig Sauer. I think I am the only guy with the Glock, and the MAIN reason I keep hearing from them why they chose Sig and not Glock was that they think the Glock is ugly. Having said that, every one of them who shot my Glock 19 loved it. They keep saying they would definitely get that if it wasn't so ugly. I can never understand that reasoning. They shoot my Glock 19 even better than their Sigs!
OK, let me wrap up by saying definitely I would buy a 226 if I had the extra cash and have bought all the other handguns I want. I don't mean to sound like a Glock fanboy because I am so new to this gun stuff I can't see how I can justify being a fan of any firearm, but I would buy maybe 2 or 3 more Glocks to round out my 9mm and .45 Glock collection first, and THEN I would definitely buy a 226.
If I had to start all over again from scratch, I think I might actually buy a 226 before I buy the Beretta 92 which I already have right now. I bought the Beretta without really knowing very much about it and was sold by the LGS on it.