In product and still life photography, you usually want your subject to be in focus from front to back. You know that the larger f/ number, the more of the scenes that is in focus. So, naturally, you may think that photographing with a small aperture (anything above f/14, really) is desirable as you'll have less focus stacking to do and the result may even look more natural.

 

However, I would agree that such a setting wouldn't be ideal. Here's why. Every lens has an aperture where it is sharper. You can notice this easily by shooting at something like f/1.4 and then, with the same subject, go up to f/5.6. You will see two things; first, the focus point is sharper, less soft and, second, the depth-of-field  is larger, more is in focus. The reason why the in-focus part looks better at a higher f/ number is diffraction. The trick to keep in mind is that a lens will perform better at the aperture value just under the point where diffraction starts (at larger apertures, like f/1.4, it is another phenomenon that causes a lens to render a soft-ish image). Here's a video that explains in a lovely manner how light diffraction works :

Every camera has a different lens aperture where diffraction starts to happen. Most of the time it's around f/8. That's why 95% of my shots are at that aperture.

 

Now, capturing images at f/8 will require more files to have a complete in-focus image. However, it will be sharper throughout. You always have to factor in if the added sharpness will make up for the added time requirement!

Cheers,

Tristan