OP, I've got a 9mm P229 w/rail. I don't carry it often, instead carrying one of several Glocks or even a small revolver (or two). Like another poster on this thread, I'll even sometimes carry one of my 1911s, still.
I'm also in the "don't go down the rabbit-hole" opinion of not constantly comparing what's now on the market; buying the latest gun; putting a few thousand rounds through it; and carrying it for awhile; only to either find I don't like it as much as something else; something else comes into the market; or I read what others are preferring or criticizing.
I own several handguns and might carry any one of them. I'm often carrying old-school Glocks 26, G19, small S&W or Ruger revolvers, or a G43. Even so, I've had my P229 since 2015 and have put ~16K rounds through it and like it quite a bit.
OP, if you're thinking of a P229, buy one and try it out. Don't even bother asking about what other folks think. There's plenty of reading about various guns to try other than in this forum. Here's a good forum for folks who can be found who really like their P229 guns:
https://www.sigtalk.com/forums/sig-sauer-pistols.14/