Rant:
Diffraction is but one of many things that affect sharpness, and it is the least among them. Others, in approximate order of significance to our daily practice, include:
- Depth of field (increased by smaller apertures, decreased by wider apertures)
- Camera shake (improved with faster shutter speeds, requiring wider apertures)
- Subject movement (improved with faster shutter speeds, requiring wider apertures)
- Focus accuracy (minimized by greater depth of field, which is increased by smaller apertures)
- Lens faults (improved by smaller apertures)
All of these are bigger issues than diffraction.
Diffraction is not a problem that just turns on at a certain aperture. It's an unavoidable effect of having a lens diaphragm. It smoothly increases as the percentage of the light affected by bending around the diaphragm opening increases. There is no one point where it becomes a problem big enough to overcome other influences.
In fact, I will happily live with visible diffraction if it means I can get enough depth of field to provide the needed apparent focus. And often the small aperture will cause much greater problems than diffraction as a result of too slow a shutter speed. The proper aperture will be selected to balance those competing objectives, and diffraction won't even be a consideration.
So, choose the shutter speed you need to control camera and subject movement. Choose the aperture you need to provide the needed depth of field. If that leads you to an aperture at f/16 or smaller, and if you can achieve your objectives by opening up to, say, f/8 or f/11, then and only then worry about diffraction.
One example I can think of is on a copy stand. I used f/22 for a series of copy photos because my lights were too bright. The result was visible diffraction in a situation where resolution was important. I didn't need that aperture for any other reason than I was too lazy to hang more diffusers over the lights, and so I had to do it over again. But if I need f/22 to provide enough depth of field when photographing a landscape, then the diffraction that results is gonna do a lot less damage than the lack of depth of field. And if I need f/1.8 to provide the blurry background I want for a portrait, it won't matter than I'm also minimizing the effects of diffraction.
Knowing a lot about diffraction without knowing those other things won't help us much. Thus, forget getting a rule of thumb concerning diffraction. Use the aperture that balances all your other objectives, because they are more important.
Okay, my rant is over, and I'm sorry for the tone of it. I feel much better now.
Rick "afraid this will offend the OP but needing to be clear" Denney