From my own experience, going off memory in some cases (some lenses since sold) and strictly IMHO:
Leica 100 APO - legendary, sharp, great color correction. Manual stop-down
Mamiya 120/4 ULD - love it, sharp, very good color correction, manual stop-down.
Leica 60mm macro - great lens, not apo, but decent color corr. Manual stop-down
Zeiss 100/2 - sharp, great bokeh, not so great color correction for the $$$. If was APO would be perfect 100 manual focus macro for Nikon/Canon.
Zeiss 50/2 - nice, but my Leica 60 was equal or better IQ for, at time, far less $$
Zeiss 135/2 APO - IF it gives you know magnification you want (can't recall) - perfect all around. Should never have sold mine.
Nikon 105 VR - very nice, but not on par with many on this list. Great to have if need AF (which I do for work), but not a 1st choice if AF not needed.
CV 125 APO - sharp, great color correction & bokeh, LONG focus throw. Price has gone nuts vs. other options last couple of years (should have kept mine ;>)
CV 90 3.5 APO. Not macro, but has close focus. Fantastic IQ if gives you mag you need.
Nikon 60 G - very sharp, nice bokeh, strong vignetting WO and color correction is not fantastic vs. other manual focus options
No experience with Sigma or Tamron, but some of their units do have a great rep. If you want to spend large $$, the Coastal Optics 60 macro is very well regarded.