What do I shoot the most? It's pretty evenly divided between small insects and spiders, and botanical subjects (flowers, insectivorous plants, fungi), although I have shot watches, jewelery, etc. During the warm weather months, I mostly hand-hold for macro work outdoors, but it depends on the subject and working conditions. (As required, I use carbon-fiber series 6 tripod, and RRS ballhead and macrofocusing rails when using a tripod, along with yongnuo speeds lites and a host of reflectors and light benders.) When indoors, I use the tripod almost exclusively. I hope that answers your question, and thanks for your reply.
Hi.
If you're split between handheld and tripod outdoors in summer, and if you use a tripod exclusively in-studio, then you're using a tripod about 75% of the time (which is my preference also).
That said, if the primary reason you're switching from 50mm to 100mm is for more "reach," this is also the primary reason I left 100mms behind years ago and went to the Canon 180mm. It simply produces better images.
I have owned the Canon 100, the Canon 100L, and the Canon 180L ... and have ditched them all in favor of the new
Sigma 180mm f/2.8 APO Macro EX DG OS HSM.
Since you're using a tripod 75% of the time, it comes with a tripod collar ... and for the 25% of the time you hand-hold it also has a great IS system.
It is sharper than any Canon, has a better bokeh than even the new 100L, has IS like the 100L, faster AF than the 180, and it has a stackable lens hood system that is pretty nifty.
If I were you, I would forget about 100s altogether (for the same reason I did: REACH), and stretch your wallet out $700, and get the 180mm Sigma.
It does everything the 2 best Canon lenses do (f/2.8/IS/bokeh of the 100mm + the reach of the 180mm) ... and does them better.
Jack