I have a p226 also, and didn't care for the p250 DAO, but part of that is me just needing more time on a DOA trigger - you may love it. The p250 has been dogged a bit by Sig fans. Not that the everyone agrees with him, but search YouTube for "p250 nutnfancy" - he really likes it and give some good feedback. Also search YouTube for "p250 theyankeemarshal" for some thoughts as well.
Have you had a chance to shoot/rent one? If you're not hung up on a .45 and willing to look at .40 or 9mm, there is a p250 2SUM, where for a little bit extra, you can get a full-size and subcompact in the same purchase - quite the value if you like how it shoots.
If you want a compact Sig .45, why not the p220 Carry (8 rounds) or Compact (6 rounds - same as the p250 subcompact)? p220 is much more popular, as it's DA/SA. The new p227 Carry will be 10 rounds, but also probably around $1000.