I don't have the 140, so keep that in mind as you read my comment...
I think just about all the rb lenses (I have the 37, the 65, 127, 150, 180, and 360) are nice for macro; I have a couple of different extension tubes and I have been very happy with them. I don't see any really offensive distortion at close focus with any of them, well, excluding the fish
I didn't get the 140 macro because the neighbouring focal lengths are so nice and you can achieve similar reproduction ratios with tubes. And they have the same f/32 minimum aperture, as I recall.
On the other hand, the rb lenses are so inexpensive now, why not pick up a truckload while you can...