Yeah, for prosumer photography and video, as well as for software development, the iPad is not going to work out at all as a replacement for the main device/desktop workstation equivalent, which is either going to be a higher end MBP or an iMac.
We've all heard about this from everyone who does those sorts of tasks, and we know iOS is still insufficient for those types of creative professions.
It still seems to me, however, that many, many people that make these complaints seem exceedingly bent on ignoring the fact that no one is trying to make the iPad their sole device, but rather their primary and perhaps sole mobile device.
Photographers and Videographers - you are not going to be giving up your maxed out iMac's or 15" MBP's anytime soon, your FCPX or Adobe Premier, your DGPU's and you're definitely not going to be getting rid of your big external RAID arrays to house all your photo and video libraries either.
Nobody is saying you should or you have to...
iPad Pro can do a lot of stuff, though, and for many white collar folk, it could feasibly be very close to replacing that work laptop or the secondary personal device like an rMB.
There is definitely some overlap here now on that end of the spectrum. I happen to fall into that side of things for 90% of my work. The other 10% is actually that creative stuff I went through above, and for that my maxed out iMac is going nowhere. I foresee needing to use FCPX for the next several years before something even remotely good enough and even comparable comes to iOS (tried to do a test video in iOS iMovie this weekend since I hadn't checked it out in several versions...but it was still heavily gimped even from the macOS version of iMovie, let alone FCPX! The program is barely suitable for a home movie clip. Boring standard and uncustomisable titles and transitions, no tools for syncing video or audio, no dynamic audio mixing, etc etc)
However, for office and business management type productivity work, it has been really good. After 3 days in the field with my new maxed 10.5" iPad Pro, I didn't even open my rMB's lid once on day 2 and 3, and thus I feel fully justified in the rationale of the purchase - in lieu of a new 2017 maxed rMB - and can't wait for the iOS 11 public beta to come out.