Among the most popular corrected close-up strap-ons, much better than cheap +dioptre sets, are the Raynox DCR-250 and -150, similar to the Canon you mentioned. With such, you maintain complete lens automation, which you would lose with cheapest macro tubes. This is mostly important if you intend to use flash. Or you can buy tubes with aperture linkage (which are a bit rare) or the old workaround: auto-aperture-link TC's with the glass removed. Remember that no matter how much extension (tubes and/or bellows) you use, a non-reversed lens cannot focus closer than its focal length. Longer lenses allow/force you to work further back.
You can get great magnification with lens-stacking using a thread-reversal ring. Your PRIMARY lens is mounted on the camera; a reversal ring is threaded onto its front; then your SECONDARY lens screws onto that. Magnification is the ratio of focal lengths, PRIMARY:SECONDARY. So a 50mm primary stacked with a 25mm secondary gives 2:1 or 2X magnification.
TANSTAAFL (no free lunch) - Limitations: With any reversed lens, your working distance is very close, under two inches. The primary lens aperture must be wide open or your image will be vignetted. Control light and DOF with the secondary lens aperture, which must be manual -- gotta have an aperture ring!
Originally posted by miltllama how does metering work through a second lens? Would I still be able to use small apertures for more DOF?
Plain ordinary thru-the-lens metering: point and meter. With a Raynox or Canon or +dioptre add-on, light isn't diminished much. With extension or a stacked lens, light IS reduced, which is why we use flash or studio lights or a tripod. Yes, shrink the aperture for more DOF -- but DOF is painfully thin at macro distances. Soe resort to focus-stacking: take shot with slightly different focus, then combine them in PP.