Sheesh folks - theory, arguments, and general "I've always heard". It's a damn rabbit hole.
If you're concerned, test your own gear.
Get a focus chart or setup a still life. (I usually just grab a software box, it's got various sizes of print and stands up all by itself). Stick post-it notes on with the aperture noted.
If you have a DSLR your lens will function on, shoot a properly exposed shot at every aperture. Hell, do halves or thirds. You'll know in approximately 7 minutes where the sweet spot of any given lens is.
Or shoot a roll of film, develop it, and do some prints. Go to town, use 5x7 paper and enlarge the daylights out of the same area on each neg. Grab a 10X loupe.
I have a blast in the darkroom, but much of my rent is paid shooting digital stills and footage. I have a pretty solid idea of where my lenses are at their best (and how neutral my neutral densities are and how diffuse my diffusion is and what color temp my daylight fixtures **really** are and what my gels really do) because it's really easy to test this stuff, especially if you have a DSLR handy.
No offense to the OP, but I'm amazed at questions that get asked that have a zillion possible answers (due to specific gear and workflow and preference) when it's possible to remove all the mystery in a matter of minutes (or a couple hours) and in most cases, learn a thing or two in the process.
TEST TEST TEST!!! OK, offa my soapbox now!