I own a P232, P239, and a P229.
Pretty much the (3) smallest pistols in their lineup. I bought them because they're great carry firearms. I had no expectation that the full size P226 would be an ideal carry pistol (for me).
If you bought a P226 to carry, and didn't like it, fine. But if you bought it thinking it was anything other than duty weapon, then that's silly.
Some folks choose to carry full size 1911's. That's their choice. Some folks choose to carry P226's, if they like it, who cares?
Your post that the gun is "overrated" is just wrong. It's "over rated" by your standards, for YOUR NEEDS.
I like a DA/SA action, and so I prefer the Sig over the Glock (although some folks don't like learning "2" triggers).
I also like the ability to run a decocker. I also don't have to pull the trigger to take down my firearm for cleaning.
There are a lot of reasons to like a pistol. For me, the Sig is about feel (in my hands), and the manual of arms.
To each his own, but I'd suggest you change the name of your post to "P226 is not good for me"...