The 50mm f1.8 works well with extension tubes to deliver good quality macro shots. It was the setup I used before I bought a dedicated macro.
timmmay: I used a Tamron macro lens on a Nikon and wasn't impressed, really poor focus.
It probably wasn't the SP90 you used then. I've found Micro Nikors to be the best, but not everyone can afford them. The Tamron SP90 is the best "bang for the buck" macro.