Hi,
Extension tubes in various lengths are very handy to have in your camera bag. They will improve the close focus of a long lens, or make for macro capabilities when used on many "non-macro" lenses. I always have a set with me and have used them on many different lenses and cameras over the years.
For my Canon system, I currently have two 25mm, three 12mm and a Kenko set with 12, 20 and 36mm in it (these are approx. lengths, without actually going and looking ;-). Singly or in combination these give a lot of options.
Basically, the longer the lens' focal length, the more tube length you will need to get into true macro territory (say 1:2 or greater magnification, which is 1/2 life-size) if that's your goal. But, to some degree this depends upon the lens and the camera being used. For example, some lenses already focus quite closely, or some D-SLRs have effective magnification built into them (1.6X lens factor on Rebel/10D/20D/30D etc.) And, you can use the tubes in combination with the 1.4X extender to get even greater magnification.
When an extension tube is installed on a lens it will no longer focus to infinity. This is okay, since the whole point is close-focus or macro. Nice thing about extension tubes is that they have no optical elements. Adding optics to the front or rear of any lens will nearly always degrade the image in some respects, a little or a lot depending upon the quality of the optics and how well they are matched to the lens being used. Extension tubes leave the lens' optical formula intact and simply can't cause these sorts of problems.
To give you some ideas, I've used 12mm on an EF 20/2.8 and had flower petals in focus while they were actually touching the front element of that lens. A 50/1.4 becomes a neat close-focus or macro lens with 12 to 25mm of extension. EF 85/1.8 also works well with 25 or more mm of extension. (Another approximationi is that to get to 1:1, or life size, you need total extension equal to the focal length of the lens. I.e., use 50mm of extension on a normal 50mm lens. However, again, it depends upon the actual lens & camera in use.)
It's been pretty well addressed already. But, the 1.4X Extender "costs" you one stop of light, which is lost when light is passing through that lens' optics. When installed on lenses that are already only around f5.6, your camera will have trouble AFing with the 1.4X installed and only effective f8, thus the hunting. Plus, the 1.4X can only be installed and is designed to work with longer lenses. In your kit, likely only the 100-400, but it sounds like that's the lens you want to use it on. Be prepared to manually focus the lens when racked out to 400mm with the 1.4X installed. (I hope you have it on a tripod, too, even with I.S., since this is the equivalent of nearly 900mm telephoto on a full-frame camera! 400mm x 1.4 x 1.6 = 896.)
Note, there is some light fall-off when using extensions, too. So, a tall stack of them might cause similar difficulty with AF. However, a lot of folks don't use AF with macro photography, anyway. I.S. is likely to be less than effective when very close-up, too.
Stacking a bunch of extension tubes together will likely slow AF and/or I.S. due to all the extra electrical connections being made. The tiny trickle of power passing between lens and camera body has to cross those connections. The more connections there are, the less efficient it is, so communication and power functions slow down.
Canon's tubes are very well made, mostly metal and I think the electronic contacts are gold plated. Kenko's seem fine, too, but are polycarbonate bodies, and probably not gold plated contacts (Hey, they gotta save $ somewhere, to sell them so much cheaper). Besides the 3-tube set offered (which is a sort of traditional way these tubes have been offered) Kenko also makes 12mm and 25mm individual tubes, which might be higher quality in some ways, aren't much cheaper than the Canon tubes.
You can get into all kinds of math and calculations of magnifications with various combos of tubes and lenses. However, I just suggest experimenting and learning what to expect with a few key combos. This might be more practical out in the field.
If it's an area of high interest to you, there are some really good books out there about using many methods to shoot macro or near-macro close-ups. If I recall, Tim Fitzharris has written one or two specifically about the subject. John Shaw's "Close-Ups in Nature" is excellent. And George Lepp's "Beyond the Basics" gets into the subject in some detail.
Cheers!
Alan