I did respond to that sibling and you can peruse my response there. Maybe it's a crazy response, I don't know, but I hope it makes sense.
We could also go on all day about things that your Mac can't do like illustrating with Procreate, connecting to a cellular network, FaceTime with a rear camera, etc, but this whole debate centers around this idea that the iPad is just this useless thing that can't be used as a general purpose tool. That idea is not grounded in reality. It's grounded in user preferences, but if we go down that rabbit hole we can definitely nitpick various things that Windows/macOS/Linux can't do.
Regarding your examples:
I'm confused about what's difficult about these file management and zip/unzip tasks. It works exactly the same as macOS [1]. You can even use a mouse with an iPad. Sure, you lose multiple Finder windows. [2] This costs a small amount of time. "Afternoon project" is a wild exaggeration. [3]
Unlike your Mac, Files centrally manages multiple cloud storage connections. For example, Filen shows up right in Files, but on a Mac you have to do some weird "mount to network share" stuff as a workaround.
You can literally run ffmpeg in a shell on your iPad: https://shaunhevey.com/posts/how-to-use-ffmpeg-on-ios/
[1] https://support.apple.com/en-us/102532
[2] We can also argue that my desktop with 3 monitors is more capable at this task than a laptop computer at a coffee shop but I can't exactly put that in a small bag and take it with me, so the iPad is just making an expected trade-off.
[3] We might even make the argument that file system manipulation has been shown to be a failure in general purpose operating system UX for the general public and that file folder organization is far too difficult for the average person. I know this idea sounds a little insane but if we really think about it I think there's some merit to the idea. How many relatives do you know who have misplaced files in a sea of folders or dump all their stuff on the desktop with hundreds of desktop icons everywhere because they don't know where else to put them? I have at least one elderly person in my life who is only able to find documents on their computer via their physical graphical position on the desktop. I submit the idea that the average person may prefer the paradigm where apps and services "contain" the data and present the data in a way that makes logical sense for that data (e.g., photo albums for photos, message feeds for messages, project structures for documents) and the data moves around between applications via the share button.
I appreciate your big picture thinking with files in (3). I have seen as well how most of the people I have “helped with computers” have no idea how to organize their files. But the iOS paradigm where the files just “live inside the apps” only works for the happy path. Create Procreate document. Edit document on this device. Using iCloud Drive by default and then you can also edit it on the other device. Everything fits in your storage (cloud or local) at once.
It immediately collapses when you don’t have enough storage space for everything at once. Or potentially the bandwidth to transfer it to and from iCloud. As the person who’s called in to help when someone doesn’t want to have to add an expensive higher iCloud tier, or buy a new $1400 phone to get higher storage, it is painful that I can barely even help solve these problems myself on that platform.
The Files app is occasionally useful and is better than the first decade, where iOS didn’t have one. But the Finder (or even Windows Explorer) absolutely embarrasses it.