iPads are great tablets - even the cheapest ones. You can't go wrong with any iPads from the last n-3 generations. But they are tablets. They do tablet-y things great. Other things not so much.
But be very cautious if you need to integrate multiple applications and maybe even those not on the iPad (like Visual Studio Code), having to restort to web interfaces or remote computing apps, terminals... Stuff exists for all of this but it's going to get progressively more painful from my experience, the more involved and "not in this single app" your workflow is.
If you stay like 95% of the time on the iPad and a very few apps in a very basic workflow (like bring a CAD drawing to the iPad before you head out), sure that's a good iPad Pro use, I think!
It’s a tool that’s really good for some things but not for others. Unfortunately, it’s the software, and not the hardware, that’s holding it back.