Depending on what you're mounting the camera on, it can be a real problem. A moderately-heavy lens attached to a tripod head turned 90 degrees for a portrait can definitely put enough torque on the screw to loosen it. This is most likely just going to be an annoyance, though, because the camera will droop but won't actually come loose. On the other hand, if you're using a "rapid" bottom-mounted camera strap, the possibility of the screw backing out and dumping your camera on the ground is very real.

e.g. https://www.photo.net/discuss/threads/black-rapid-and-other-...

"I definitly have had issues with the tripod socket mount coming loose during carry. It is rare, and usually only after a very long time of not adjusting it but I came within a wisker of dumping my F5 one time and the D300 has seen it loosen up a couple times."

I'll second this, and note that this is a problem more significant in practice than in theory.

Speaking as a physically inept "software and pure maths" person with consequently no authority whatsoever on this matter, I believe this is mostly on account of the usual "thumb-screw and rubbery no-slip pad" construction of typical non-camera-specific mounting hardware: while it's hard to imagine any lens without its own tripod mount is capable of enough torque to loosen even a hand-tightened bolt, as soon as the non-slip pad ceases to be effectively rigid, very little torque is required to loosen the bolt. And as with most (all?) "rubbery" materials, stiffness of a given non-slip pad at constant compression is a function of temperature.

I think it has more impact on very long exposure shots that can span 30 minutes to hours where a breeze can ruin a shot of it moves in the slightest.

But I agree. I think for the majority of shots it doesn't make that much difference.