Yeah for sure everything you say makes sense, but at the same time there is a definite lack of software that makes use of all that power for a broader range of professionals.

Personally, I'd love to replace my aging MacBook with a small and light iPad Pro that I can also use for convenient note taking on the go, but the problem is a complete lack of a (viable) software development stack, and that's despite IDEs like VSCode being web-based and with that theoretically capable of running on iOS. I know some of my friends are in the same situation; one of them relies on Blender, the other on Ableton.

The inability of running two instances of Word / Excel etc. may very well be Microsoft's fault, but that doesn't change the fact that as a user you can't do it.

In theory I guess a Surface is exactly what I'm looking for, but switching to Windows would be a bit of a hard pill to swallow. Which is why I'm left wishing that Apple would offer some kind of hybrid tablet / laptop device like the Surface, capable of running full desktop apps and full desktop-style multitasking. I understand that that's "not the vision" or whatever, but it creates an awkward situation where the hardware of this lineup is more than adequate but the viability of the device as a whole is limited by software.