In power, no doubt the .40 is better. It's right up there with .357 mag in performance with the lighter loadings. I've never really seen the point of .357 sig. If you load the .40 with light bullets, it'll put up energy levels equal to the sig. The velocity might be a little off 'cause light is 155 grains in .40, but it's still pushin' some decent velocities and making 500+ ft lbs from a service sized gun. If I used the caliber, I'd use light bullets.
I, however, carry the 9 and consider it quite enough. It's an impressive little round in little guns, beats .38 special +P, and is easy to shoot well. The .40 can be a handful in a light, compact auto. The main game plan is to be able to hit what you're shootin' at and I'm a little more confident I can do that with the nine. But, I admit to the .40s superior ballistics.
I've always disliked the "iffy" nature of the 9 m/m because more things must align properly for it to be effective as a stopper.
So, you can hit a guy in the foot with the .40 and he dies instantly? Either bullet needs to be put in the boiler room to work and either will do the job IMHO. Yeah, the .40 does have more sauce, but a 9 in the heart/lungs is better than a .40 in the shoulder. If you're confident in your marksmanship with the .40, fine. If I carried a full size auto, I'd consider the .40, though I already have a nice .45 and my full size nine packs 16 rounds of +P+. I still don't think I'd buy a new gun just for the little extra the .40 offers. However, if I was buying a new gun and didn't already have something that works, yeah, I'd likely get the .40 in a full size gun. I chose the 9 in a compact, though, cause in a 14 ounce gun, the 9 is more controllable.