Anyway that's my rant. I know the iPad isn't for me. I just can't understand who it IS for and why they keep selling. Every use case I can think of, a MacBook does it better (with the obvious exception of the pencil). Maybe if they cost LESS than a MacBook I wouldn't be so grouchy.
Just addressing the part in
bold.
It’s perfectly understandable (at least to me) why the iPad as a device (considered in the abstract) may not be useful for you. It’s software limitations are obvious and in many ways, the way Apple prices the premium versions makes the ROI calculation sometimes difficult to swallow.
That said, your key question was:
who is it for?
I am one of the people for whom the ipad is ideal. I sy this having first tried out a number of Android and Windows tablets. While they have all been good in their own ways, as much as I initially resisted the lure of the ipad, I had to accept that it was a device uniquely designed to - or so it seemed to me - to address my specific needs.
My work involves a lot of reading and note taking. When I say a lot of reading, I mean a lot! The ipad - as much as I hate to say it - has an excellent ecosystem for doing just that. Further, it’s aspect ratio is ideally suited for reading. The Pencil works flawlessly on various note apps (I limit myself to Apple Note and more heavily on OneNote). I am constantly using OneDrive to access my files. And the best of all - when I step out of my apartment with my phone, and my laptop, I am not simply carrying my “office” with me, I am also carrying my reference library which has a little over 8000 texts. That means I can literally sit anywhere (assuming I have a network connection of some kind) and work or engage in non-work related activities.
Others - I am sure - will have other use cases involving editing photos or videos or mixing music and other lot of sophisticated activities, but my example stands as one very basic instance where the iPad has proven to be an essential part of my kit and thus my workflow.
Let me also say this: Just because I seem to be singing paeans of the iPad, that in no way means I am in the Apple ecosystem. I most certainly am not. I use a Samsung S22Ultra as my phone and a ThinkPad Carbon as my trusted laptop. In that sense, I am a digital mongrel. The Microsoft office suite including OneNote connects my devices as does some platform agnostic apps for social media and messaging.
So, as you can see, in a limited sense, the answer to your question is:
It (the ipad, that is) is for me! Or, someone like me!
Edit: I forgot to add - I have two iPads, the 2020 11” IPP & the iPad Mini 6, and yes, they play different (but in some cases overlapping) and essential roles for me.