All of those sports require vastly different movement skills and so on. some of which are better served With machines, some of which are not, some of which requrie vast amounts of strength and size, some of which do not.
You probably don't, but that is not the point. Squats are a compound exercise, they don't just hit your quads, they hit your hamstrings, gluteus, hip stabilizers, and back, and various core muscles. All of which you use in day to day life and virtually every sport.
A let press is also a compound exercise .... and so what, compound exercises are good for somethings, somethings are not ... you use Your Whole body in many sports and in everyday life.
Guess what, in everyday life most People in the west sit at a desk or in a store, in front of a computer.
Of course the function is outside the gym. However, ultimately strength for all intents and purposes is your strength to weight ratio. If strength training doesn't translate into being able to better move your own body around then there isn't much point to it. For example, a 600 pound man that can't even walk on his own might be able to bench say 250 pounds if you somehow got him in the position to do so. If a 160 pound man could bench 180, I don't think anyone would argue he was not stronger than the 600 pound man. I don't care how much someone claims they can lift, if they can't do a pull-up they are not that strong. If they can't crank out pushups and maintain proper form, they are not that strong. If they can't do dips, they are not that strong.
No, for all intents and purposes is NOT Your strenght to weight ratio, if you're small, and can lift a lot for Your size ... you can still probably lift less than someone who is twice Your size and average strength for his size, the latter guy is OBJECTIVELY stronger ... the thing being lifted doesn't know, nor does it care how big you are.
Strenth training DOES translate into being ablto to better move Your own body, as does all sorts of other training.
If you can do a backflip and whatever, but ultimately, I can lift more than you, I'm stronger ... plain and simple, it doesn't matter how big I am, I am OBJECTIVELY stronger.
now they may be weak for their size, but they are still stronger than a tiny guy who is strong for their size ... objectively.
This idea of "functional" strength is nonsense, functional for what? I Train quite a bit, I don't do navy seal stuff, i don't get in fights, I Train in a way that People would classify as "functional" (ring work, kettlebells, chinups, dips, straps and so on), because it Works better for me, but I'm not dillusional by thinking that somehow training that way makes by body more "functional," whatever that means, than doing straight weights and machines, it doesn't, the function I get from it is trained outside the gym, the function ig mostly gives me is *****-getting ... and thats why most men Train, and thats ok, most of them are not jumping over cars and cutting Down trees With axes or whatever, and if they did, weight training wouldn't make them good at that, actually practicing those Things would. weight training puts muscle under tension nad Trains the CNS system ... THATS IT.