Most glasses are at their best stopped down to f/5.6-f/8. I think that this is a rule that we can all agreed on.
A lens stopped down, for the same exposure, will either need a slower shutter, or a higher ISO. If one wants to maintain a low ISO to avoid noise , then one has no other option but to slow down the shutter. A slow shutter introduces the risk of blur (which destroys sharpness), because most people (like me) can't hold a camera steady beyond 1/focal length, so I have to resort to a tripod to remove user-induced blur, to increase my probability of making a sharp image.
Now, if we stop down to f/5.6 or f/8 with the hope of achieving the glass' sweetest spot, will a tripod-mounted shot be sharper than the handheld? I'd say 9 out of 10, yes.
Will every lens be acceptably sharp with a tripod? No, but stopped down, chances are it's still sharper with, than without.
As for cameras being sold welded to a tripod, that will start an entire forum argument as to whether carbon fiber is really better than aluminum or not