I love my SP-01 Tactical after giving it some CGW mojo. Such a great shooting and accurate pistol. It's not a carry pistol for me, though. On the other hand, the SP-01 is no heavier than a lot of full-size 1911s, and obviously plenty of people have carried those for many years. As with all heavier guns, the right belt and holster can make a huge difference.
Back on topic, though I own several nice Sigs, I keep coming back to the P-07. There's just something about it that I haven't found in any other pistol I've tried - the combination of accuracy, great ergos, and reasonably light weight for it's size. So far I haven't done much to it, because the trigger was actually pretty good on this one out of the box - I gave it a thorough cleaning and light polishing, installed the CGW #18 hammer spring, reduced TRS and DA roller bushing, and threw a bright orange Night Fision front sight on it, and it's been GTG. And because I prefer AIWB carry, there's something very reassuring about being able to thumb the hammer when holstering.
Oh, and this thread needs pics...