In the standard Sig Double Action/Single Action trigger, the trigger pull is not too unlike others of that type ... a little long and mushy for the initial DA pull, then decent in the SA mode thereafter. For one thing, they purportedly get better with time; so an initial test in the store isn't necessarily as good as it will be after 500 rounds. Also, many people change out the springs, giving a different feel.
Further, Sigs have some variations on their triggers, including an aftermarket "short" trigger (reducing reach a little), a "DAK" trigger, which is a double-action-only system, single-action-only (on some models), and a short-reset trigger (also only on some models, I think, and needs to be done by a gunsmith). Each is a little different and has its fans and detractors.
I recommend you go over to "Sigforum.com" and ask there under their "Sig pistols" sub-forum (you'll have to "register" to ask stuff). Those guys know EVERYthing about Sigs and many own a lot of other guns, too, so they can give you good comparative information.