Sharp lenses with wide apertures (F/2.8 or larger) work best with extension tubes. Because you are magnifying your images, it helps if the lens is already sharp and a wider aperture will help you collect as much light as possible.
50mm Prime Lenses - "Nifty-fifty" prime lenses are cheap and extremely useful for a wide range of subjects. A stack of extension tubes on such a lens can allow you to get extremely close and still have stunningly sharp pictures.
Macro Lenses - If you want to go beyond 1x magnification, an extension tube and/or teleconverter is the best way to achieving 2x+ magnification for double, triple, and beyond life size!
F/2.8 Zoom Lenses - Some of these lenses have small magnifications and long MFDs so an extension tube will allow you to be closer to your subject should the occasion arise.