Sadly many people are too narrow minded to think of any use cases beyond their own, and then complain when the product doesn't meet their use case exactly.
It probably just means the product is not designed for you.
I think iPads are exactly like you describe... perfect for casual media consumption, light work, email, web browsing.
Big phones... plus a bit more.
Little laptops... with a little less.
Like when cars go through product iterations and grow bigger and more powerful, the iPad has matured into a hardware beast now far beyond the initial job.
The new hardware making it the fastest and most powerful device has maybe clouded the intent.
And a few people think it should do more to use that power.
Either iPadOS needs to change and allow it or a way to load some MacOS onto it.
I have a foot in both camps as I can see most of my iPad time I dont need something more desktop OS strength.
But them other times (like going on holidays), I'd love an easier way to load videos and music to take with me. iPadOS is still not great at files. Airdrop isnt quite flexible enough (want to put movies in Photos app rather than in VLC).
I end up taking both iPad and Macbook. Just in case.
It would be great to take a couple kilos less hardware.