@sharkbait13 I think the reason people dismiss it, is for a few reasons. First, if you do the basics, you'll be strong enough for the things you describe, and can you really construct a program that encompasses every possible 'functional' scenario that you can apply progressive overload for?
I don't think you have to do these things to be fit, or jacked, but the typical lifts are pretty safe if you aren't stupid, there is a lot of information to make progress, and have a track record of working out.
If you do your program you'll be fine really, like perhaps your risk of injury is higher depending on what weird exercises you do for your functional part but overall it's whatever, the harder part is just about doing your things consistently, rather than being dogmatic about the particulars one way or the other.