Regarding camera lenses - the brands that match your camera or generally more expensive - some would argue to a point you get what you pay for - quality glass, quality METAL pieces in lenses (vs plastic), etc. My friend and I have compared the 100mm Canon macro to the 105mm Sigma macro - and they do have some interesting differences, as they probably will with the brands you note as well. My friend actually preferred the Sigma and sold me his Canon! Whether they will be signicant for your use is for you to decide. For one thing the Sigma is not "fixed" in physical length as it focuses it lengthens/shortens - unlike more expensive lenses. It is lighter - which some people like. Any of the brand lenses you have noted will last you a lifetime and make great photos.
I took some pictures to compare lenses - using my Dtps Pucherina X Dtps Budda's Treasure as the subject. :-) All pictures are resized to about 800 X 533 and no post processng has been done. WHAT DO YOU THINK?????
First a pic taken with my standard inexpensive 18-55 kit zoom lens.
First pic taken at 18mm - as close as I can get - about 12 inches.
Next picture taken at 55mm - as close as I can get - about 12 inches.
Next picture taken with my 55-250mm kit zoom lens -at about 250mm - about 3-4 feet away - as close as I can get!
Next picture taken with my 100mm Macro lens - as close as I can get - about 10 inches
Last picture is taken with 100mm Macro lens - about 2 feet away - to show nice two bloom pic with this lens.
