A Sigma has the worse trigger pull I have ever felt on a handgun. If you need a bargan home defence pistol fine but if you ever want to hit anything more the 10 feet away find a different gun.
But, (*prepares to dodge the onslaught of tomatoes*)
and I speak from experience, the trigger pull will loosen up after you shoot it for a while. I bought one in 9mm because I wanted a new toy and was told they aren't too bad for killing paper at close range (and they aren't, by the way) and the first time I ever shot it it was at a 25 yard silhouette, and out of the 15 shots in the magazine, I hit the target 9 times! I was confident I could do more damage (and do it more accurately) if I just threw the gun at the target. Well, after putting two 100rnd boxes of Winchester plinker ammo I can tell you that the trigger is now about half as heavy and bad as it was originally, and now hitting the target 15/15 is not a problem (as it shouldn't be, regardless of what pistol you are shooting, since it's only 25 yards.) And from a sandbagged rest at 25 yards with the same mass-produced plinker rounds (115 grain FMJ, btw) we got consisten 3-4 inch groups with no fliers.
Now the only time the trigger seems really bad is when you fire it right after an extensive shooting session with a traditional single action. Accuracy is fine for normal engagement distances, and reliability is great, with no FTF's, stovepipes, jams, etc. And the 16-shots feed great. Basically (*prepares to dodge the second volley of tomatoes) it feels in every respect like a $250 Glock.
But, after having said all that, I would not recommend it for a concealed carry gun (if that was your original inquiry, I don't even remember) because it is really difficult to make very quick, accurate follow-up shots or double taps. It still has a long trigger pull. I might recommend one for a back-up carry gun, since those would only be used in the worst of situations where all that is required is that it goes bang each time, which it will. But, if you ever need to resort to a back-up gun, you would probably be in desperate need of very quick successive shots, which this pistol will not give you. It also makes a good cheap home defense pistol or, and again, back-up home defense pistol.
As for the gun you should buy, I agreed with the last few posts. Check out a police auction of used duty guns. Great pisdtols which are generally in very good condition. As for the specific handgun, I would suggest a used (real) Glock, or some version of the 1911. Sigs and HK USPs are also very fine weapons, but a bit pricey. As for caliber, I'm a .45 man myself, though the 9mm is cheap, accurate, offers good penetration and is light-recoiling, and the .40 offers a good compromise between power and magazine capacity.
I guess the age-old advisories apply: go to the range and shoot everything you can get your hands on. Go with the pistol that fits you best and that you are the most accurate with. These especially hold true if you plan to carry it, because you have to be sufficiently good with it and confident in it, since it will do you no good if you don't like lugging it around all day. "A .22 in the hand is always better than a .45 at home."
Was this post even about carry guns? I am far too long winded for my own good...