The Tamron 90 is a great performer. Very pleasing bokeh and sharp as a tack. My son and I both have Nikon bodies - mine is a D90 and he has the D5000. I bought him the Tamron for Christmas and I was very impressed with the image quality.
It's very light and a bit cheap feeling with regard to construction. I wouldn't think it could take much abuse, but then I don't abuse my kit. The only tangible drawback to the design of the Tammy is the fact that the barrel extends as you focus it.
Some people feel this is a huge negative, but I never felt it got in the way the few times I used it.
I would have no problem buying any of the following macro lenses:
Sigma 105mm f/2.8 (OS or older non-OS)
Tamron 90mm f/2.8
Nikon 105mm f/2.8 VR micro.
Nikon 105mm f/2.8 non-VR
I love the older 105 non-VR nikkor. I f you can find one used and in d=good condition, don't hesitate.
The bokeh on the older lens is supposedly better that the updated VR version, but I have never used the new one so can't speak from experience.
I have used a friends older version (I don't think its 1:1 macro, but I would need to check on that) and I loved the results.
I think you can pick these up for between $400-$500 depending on condition.
These were taken with the older non VR Nikkor 105mm f/2.8:
Have fun!