Ok ok lets not go too insane here shall we?
First up lets look at the rough maths for extension tubes and what you get with them. For extension tubes the maths for magnification is:
(length of the extension tubes in mm - divided by - focal length of the lens in mm ) + base magnification of the lens = magnification : 1
For example a 100mm macro lens at its closest focusing point (ie magnification of 1:1) and adding 50mm of extension tubes would be:
(50/100)+1 = magnification :1
which gievs
0.5+1 = 1.5:1 magnification
Those are rough numbers since the actual focal length of most macro lenses at 1:1 focusing distances is a little shorter than stated and since you'll likely have a different value for the extension tubes (eg 65mm). However, as you can see, it does give you a decent boost to the magnification possible with the lens.
You will, of course, lose working distance and also lose infinity focus when using the extension tubes (as on any lens). If you start adding extreme lengths of extension tubes you can run the risk that the setup becomes very forward heavy and very difficult to use in the field. In addition (though this tends to be an issue with shorter focal length lenses, unless you start adding extreme lengths of extension tubes) adding extension tubes can run the risk of moving the focusing point so close that it actually ends up inside the lens - by which point the lens can never focus. But its unlikely to happen with a 100mm lens and you are more likely to see it a problem on 40mm or shorter focal length lenses.
Personally for smaller gains in magnification I prefer to use a teleconverter; a 1.4TC gives you almost no loss of optical quality (esp if you're taking your macro photos at smaller apertures) and also lets you retain the full working distance and infinity focus. It gives you what you'd expect as well - 1.4 times the magnification or 1.4:1 on a regular 1:1 macro lens.