After a LOT of research and reading many forums and reviews, I found my lens!
I missed out on a Tamron 90mm Di, but it might have been a blessing in disguise. I ended up picking up a mint condition Sigma 70mm F2.8 f/2.8 EX DG Macro for a little over US$300.
From everything I've read, it's about as good as macros get for my purposes. It's super sharp, the perfect focal length for me (with sensor size, it takes it to 105mm - I think!), and has very good build quality.
I haven't read a bad review on it and it won a few "top lens in class" awards in the past year or two.
I'm not worried about resale value. I don't buy lenses thinking about selling them. I buy them because I want them