Everyone's workflow is different. I can do about 90% of my core, non-day job stuff on an iPad. Some of that remaining 10% may never happen. I don't expect a full version of AutoCad, Tableau, or Calibre to work on iPad.
The new iPadOS does remove some of the barriers. Being able to connect to servers, USB drives, and being able to just move SD card photos to a specific app, or just offload them to a folder in Files is huge.
How do you achieve that connectivity, moving files etc, between iPad and MPB/iPhone? As explained in thread I've just started, I am about to buy an iPad - likely the iPad Air 3 but I'm also considering the iPad Pro 2017 - and have iPhone 7 (with lightening) and MBP 2015 (with USB 3). Also, what is recommended by way of keyboard?