Here's the thing.
You don't need to understand other peoples desired or required workflows for them to be valid. Not everyone has the same needs or desires as you, but when Apple advertises as they did again recently that iPad can fully replace a computer... yes, people are going to be mad when they buy a fully loaded iPad Pro for $2700 and find it can't get the job done due to artificial limitations from software decisions Apple makes.
Also, hate to break it to you.... but 1% of the iPad user base is probably 30% of the iPad Pro user base. If you are going to make such a high-end machine, your high end users are going to expect to have an actual use for it.
I don't buy a Volkswagen and then get upset that it's not big enough to transport a sofa home.
Could the iPad be more? Perhaps. But I think Apple also walks a fine line between adding the functionality that pros want, without alienating the rest of their user base who may not necessarily need the extra complexity.
The iPad and the Mac each has its own respective strengths and weaknesses. There is some overlap in functionality, but overall, there's work I prefer doing on an iPad over a Mac, just as there are tasks that are easier to perform on a Mac over an iPad.
I don't buy an iPad fully expecting it to be able to replace my Mac. Rather, its value for me is in adding value to the Apple ecosystem by letting me do the things that I couldn't do on a Mac (or at least, tasks that just aren't as nice to do on a PC). For example, I could record a screencast on a Mac by attaching an expensive Wacom tablet to it and recording myself writing on a pdf document via Quicktime.
Or I could just turn on screen recording function on my iPad, write as I normally would in notability with my Apple Pencil, make quick edits in lumafusion, then upload directly to YouTube. The process is quicker and more convenient (because I can do this anywhere I have my iPad and 4g with me, without the need to set up additional hardware).
And the latter works precisely because of the simplicity of iOS. The iPad Pro is the best computer I’ve ever owned not only because it’s powerful, but because iOS apps unlock a different kind of productivity on the big screen.
I am not sorry I got my first iPad in 2012, and embraced new ways of working on it. I was able to optimize my workflow on a computer that can transform into a laptop, a book, a videogame console, and a focused whiteboard when required. I’ve had fun working on the iPad Pro and more importantly, I’ve accomplished more thanks to the power of modern iOS apps.
Perhaps what is needed here even more is a paradigm shift in the mindsets of the users here. Rather than try to force your existing Mac workflows onto an iPad, maybe start by asking yourself how they can be reinvented for iOS. It can be frustrating at the start because it often requires you to redesign your entire workflow; it's not as straightforward as downloading an app and syncing your data over.
At the end of the day, it's really about being cognisant about what the iPad can and cannot do, and making a judgment call there and then.
But when you do, it can be just as rewarding.