Can you elaborate a bit on this? I don't think I have any missing software on my iPad in relation to my macOS workstations. I'm pretty easy; OmniFocus, DEVONthink, Due, Fantastical, Lightroom, and Obsidian is in test flight now and that's the only app I feel like I'm "missing". My career is in IT Security and my hobbies are photography, publishing, and drones.
During the work week my iPad spends about 1/4th of the time in OneNote because that's my whiteboard when I'm conducting workshops.
As for Final Cut Pro or something on iPadOS, I would imagine most filmmakers need more storage than an iPad Pro will give them unless they plan on hitching it up to a JBOD or something and being tethered. Which might be totally fine and what filmmakers want, that's definitely something I don't know anything about. I use iMovie occasionally and that's it.