Well Simon, you can see my macro-gear in my sig.
As to the Tamron adaptall I can't say a thing
But loosing autofocus for macro work can be a heavy penalty when you're shooting freehand. That's where the continuous focus of the D80+AF-lens comes into great play as you're not only shaking (leading to my next topic) but also moving back and forth (you
plus your subject). In these situations you'll never be able to manual focus or even find the right split second where to pull the trigger
If you're mostly shooting inanimate objects from a tripod, you can easily live without continuous AF (and anti-shake).
So lastly think about anti-shake with taking macro photos. As the magnification goes up, so does shake.
So the reasons why I invested in the Nikor 105mm VR - although that was a lot of money: I don't normally lug my tripod around.
_________________
Thomas (beware: Nikon-fanboy and moderator!)
My Lens Reviews,
My Pictures,
My Photography BlogD800+assorted lenses