Most of my studio photography experience is limited to my timespan as a turner (not extensive), but I do have a good bit of wildlife and nature photography experience. The sweet spot is definitely a thing, and no one can argue against sharpness and saturation being important. However, in practical settings I definitely favor depth of field over the sweet spot. Usually, currently, I try to shoot around f8/f11, but when I was doing a lot of macro work with creepy crawlies f16 was pretty standard (assuming I was also using a flash). Or more wide open if appropriate—the bigger the creature, the more wide open I tended to shoot (as I wasn’t as limited by distance to subject). As an aside I do have some old cool glass that generate interesting bokeh
Post-processing software is so advanced now that diffraction issues with small aperture is a negligible issue. Likewise, lack of sharpness for not being in the sweet spot can also be corrected in post in most circumstances. Obviously, exceptions apply. Depth of field can be a stylistic choice, but for photographing turnings I think the only circumstances for shooting wide open (ish) is for detail shots or for photographing something like an upright platter. Not to drone on too much, but like others mentioned, sensor size is also so important. Again, post has marginalized some of the differences in sensor size (regarding crispness, saturation, etc…). Sensor technology, too. BUT I still fantasize about a full frame sensor with only 8 or 10 MP. I went down the rabbit hole last night and almost bought an old Canon 1d mk2 for a steal, but apparently it’s difficult to find batteries, a charger, etc… Body maintenance and support issues as well. I do miss the feel of a large blocky grip.
@Bill Alston that’s awesome about the in-camera focus stacking of the Fuji. I’m a bit green with envy. Years ago, I almost pulled the trigger on the Fuji x-h1, but I wanted a full frame so opted for the Sony (and found a killer deal on an a7-2, as the a7-3 was just released). Late 2018 when I bought, I think?