I had one a few years ago when I had a 20D. Very very sharp indeed. As you say, possibly a bit short for macro at times but it doubles up quite nicely as a portrait lens and it's cracking for product type shots. I've never really heard anyone complain about it at all.
There are times it's not the fastest focussing lens and it can hunt a bit on AF but to be fair you're more likely to use it on manual focus for macro anyway, so not really a problem. I'd highly recommend it anytime!
cheers