Too many variables to calculate with any reliability, the biggest one being 'becomes noticeable'.
Diffraction will be measureable at quite low f/numbers, but the point at which this becomes 'unacceptable for my own personal use' is another question altogether. Generally speaking, with macro the priority is getting sufficient depth-of-field. It's no good having one area of the subject pin sharp when everything else is just a blur.
Spot on.
Some other aspects of the equation are that it depends what size sensor you are using, it depends how much depth-of-field is enough for your purposes and it depends on how much you crop.
These days I have reverted to using a bridge camera with a 6mm wide sensor for my close-ups/macros (which is most of what I do, using achromats). f/8 is the smallest aperture on my bridge cameras, and it gives depth-of-field and loss of detail/sharpness similar to those you get from using f/22 on a micro-four thirds or APS-C camera. I believe the equivalent in terms of depth-of-field and loss of detail/sharpness for a full frame camera is around f/45.
Here are some examples of apertures several fine macro photographers use.
Kurt (Hock Ping GUEK) orionmystery often uses f/11 with an APS-C camera.
Brian Valentine (LordV) often uses f/8 with a full frame camera; he goes far beyond 1:1 by the way using an MPE-65.
John Kimbler (Dalantech) often uses f/11 with a full frame camera for macros, including high magnification use of the MPE-65, and around f/5.6 to f/8 for what he terms close-ups (1/4 to 3/4 full size).
Mark Berkery uses f/11 with a small sensor (in his case 7mm wide sensor) bridge camera (using achromats), and I suspect this might be nearer to f/32 than f/22 in terms of its equivalence to APS-C depth-of-field and detail/sharpness loss.
For my purposes (mainly screen display 1100 pixels high, and occasional prints of A4 and very occasionally 16x12) I find minimum aperture is fine. That is for invertebrates. For flowers, berries, buds etc, including some rather small ones, I tend to use larger apertures, but that is for depth-of-field purposes not sharpness/detail issues. FWIW here is
a set of invertebrate images containing two images from each of four cameras (using achromats), three bridge cameras and a micro-four thirds camera. All were captured using the smallest aperture available: f/8 in the case of the bridge cameras ans f/22 for the micro-four thirds camera. (For some reason Flickr refuses to show these at the intended viewing size of 1100 pixels high unless you specifically ask to see the "Original" version for images individually.

)
If you use less magnification and crop you gain in depth-of-field but lose detail compared to capturing the same scene using the whole sensor. How that trade-off works out in practice is, like apertures (and for that matter shutter speed, ISO, the use of flash and/or tripod and stacking) a matter of experimentation and may vary with subject matter and motion, ambient conditions, camera and personal preferences as to working methods, post processing and the look and style of the finished product.