Sig probably has more variations of different models than any other maker out there, first thing's first, browse their CATALOG, that will let you see most of the different models out there and should explain most of the acronyms.
The models you seem to be interested in are the 226 (full size) and 229 (mid size) and possibly the 239 (mid size, single stack magazine), multiple variations of each are in current production and Sig has something for everyone.
Your "common" acronyms related to Sig are:
This refers to the trigger type(s):
Double Action/Single Action
Double Action Kellerman
Single Action Only
Short Reset Trigger
You can read up on the differing trigger types here: Trigger Types Defined and Explained. I will add that the SRT is a traditional Double Action/Single Action that has a shorter reset (the point at which the mechanism is ready to fire again)
Some other terminology is SAS, this refers to Sig Anti-Snag, the SAS models are guns that have been "dehorned' which is a rounding of the corners etc removing the sharper edges.
SCT refers to Super Capacity Tactical, they made some changes to the standard models such as the short reset trigger, extended capacity magazines, differnt sights and some cosmetic changes such as forward cocking serrations.
Regarding the muzzle rise, that's a matter of opinion and will vary from person to person, Sigs have a higher bore axis than some other guns and to me have a little more muzzle climb that some different makes and modlels. Bore axis is simply the height of the barrel in relation to the firing hand. A higher bore axis places the muzzle higher above the hand.
Again, as there are so many models, the website and the catalog are probably the best way to go. If you go to a good gun shop, they should have a catalog that you can take home and look over.
I'll work on another post going over most of the models, but it takes some time.