No experience here with the P-07, but do have considerable time with a variety of Sigs. (P226, M11A1, P225, P365, P290, P220, Sig 1911 RCS)
Here is a rundown on my experience with Sigs: All are of excellent fit and finish...all fed and ejected at nearly 100% reliability, and all had great DA triggers and good SA trigger functions. Accuracy was all that I needed at defense distances and were capable of playing card sized target area hits at 15-20 yds with good steering on my part. Closer in, at 10 yds, slow fire groups hovered around 1"+. They're expensive if bought new, but a bit cheaper, of course, used. Any one of them would be my first choice.
The P229 or M11A1 (P229), fits your Compact size criteria and has the capacity you've specified. In both 9mm and .40 S&W, as I have a caliber exchange unit, my example is superb.
Ergonomically, even with my Size "L" paws, the double stack models (P226 & M11A1 or P229) have a large grip in circumference. Troubling to some, but trainable in my case after a few hundred rounds. The P225 has the best overall grip feel for me, but it's a single stack.
For conceal-ability/capacity/overall usefulness as a CC choice, the P365 is the best choice in my opinion. Accuracy with it is very close to either my P226 or the M11a1 in fact. It's a hellofa fighting pistol...and for those concerned with its teething problems...they're in the past as far as I know and mine has been trouble free for over 1300 rounds now.
A word on sights: Tritium night sights would be a must-have on any carry/HD gun if I were buying.
YMMv, HTH's Rod BTW, I'd opine that the P226 is a bit large to CC on a regular, all-seasons, basis.