Prime lenses are usually optimised by design in order to be as sharp as possible in "average" working conditions, that is when the subject is far from the front lens and the film is close to the rear lens. (As a side note, this is why enlarger lenses, which are optimised for nearly equal paper-to-lens and film-to-lens distances, are so good when used as macro lenses). When the reproduction ratio is such that the subject-to lens and film-to-lens distances are comparable or inverted, inverting the lens as well might be favourable.
However, as you already noted, there are not many accessories that can be mounted on an inverted lens. Actually I don't remember any brand that used to make any.