I've got a '96 P226. This was the last year of the folded stamped sheet metal slides w/ pinned breach block. I recently put an E2 grip and mine and it fits my hand much better. My buddy has 2 P226's of the same generation.
For starters, my wife's favorite pistol is the P226. She's sort of commandeered mine. Can't think of a better endorsement than that!!!
Seriously, I like the P226. It is VERY accurate and reliable. In my mind, when I think of a DA/SA metal pistol, I think SIG. I think they are as good as it gets in regards to metal frames and DA/SA triggers. Beretta is a close 2nd. I've shot examples of other "P" series pistols, ie; P220, P229, P228, P239. All have been very accurate and reliable. I don't think you'll go wrong w/ one.
I will say this though. I do think the idea of the "ideal" combat pistol has moved on. Consistent triggers and polymer frames and all. Glock had a lot to do with this. As much as I like my SIG, I have no problem letting my wife run w/ it. These days, my go to pistols are Glocks and M&P's. I much prefer a consistent trigger than battling a heavy DA trigger. The P226 rarely sees the range these days.