You get more magnification, but your working distance and DOF decrease and light reaching the sensor is less, so you need a flash.
I use 48mm of tubes and a 1.4 TC (the TC increases the working distance and gets more magnification) on my D90/ Tammy 90 combo along with a diffused SB600 flash to get this:
Common blue damselfly by
jomike, on Flickr