As a software developer it's easy to mistake "producing" and "productive" for "coding", but that's only one niche.
(MS Surface seems to be popular with comic artists, and even though they have a PowerShell at their disposal, I suppose they are using their Surface much like an Apple user can use his iPad.)
My experience with spreadsheet softwares on ipad is terrible compared with a desktop experience. And for word/powerpoint we are back to my point on editing something without a mouse and keyboard. There are some case in powerpoint where a stylet would be quite powerful (for drawing shapes) but in most use cases it is hard to beat the keyboard + mouse in term of precision, speed and small amount of effort required.
I can understand how it can be used by artists for sketching but I would think it's more of a niche market.
I also bought an iPad Pro and Pencil. It beats my Wacom Cintiq. Especially because I prefer iOS painting software — Procreate in particular — to Photoshop. Procreate can handle large layered canvases at a smooth 60fps, on far less powerful hardware than Photoshop. It offers most of the same features for painting in a nicer package. It's far cheaper, and they have supported the app for years. I have been a graphics tablet user for over a decade and the iPad Pro + Pencil is the best digital drawing experience I've had.
I also kind of like coding on a software keyboard. Probably not for a big project, but it's what I go to when I want to build interactive prototypes.
"Working Copy" is a neat Git client I have been using on iPad. I use it to read my code base for large projects and to manage my commits and pull requests.
I hear a lot of musicians like the iPad for music production, but I haven't done much outside of GarageBand.
I have no plans to stop using my laptop computer. But the iPad is a great screen for making things, even if you might have to take those things to a laptop later on to "finish" them.
It's dangerous to bet against apple these days but combined with a small ecosystem of professional authoring apps (compared with MacOS or Windows), I am not very bullish on the pro.