Funny though, the lack of sophisticated Office apps is why I stay away from the MBP altogether for work. Office is just horrible on OS X with lack of features and bad optimization, I really wish that Microsoft would put in the effort to make their software good on other platforms (including iPad OS).
As a fun test I did try executing some heavier Python calculations on both the iPad Pro and my Lenovo work laptop (with a 9850H CPU) to test and the Lenovo was just about 15-20% ahead. Not bad since the Lenovos fans were audible while doing it and the iPad Pro is this quiet unit with much better battery life. So the power is definately there now, just need the software to catch up.
That used to be true a few years ago, but the current Office 365 Suite has worked equally well for me on both PC and Mac. I think they are at feature parity. If not 100%, then very close. I use both at work. The features seem to be exactly the same. In fact, I find the Mac version faster to use, because it has a dedicated Menu bar and not just the ribbon. I spend less time searching for rarely-used tools on a Mac.
Maybe there’s some edge case you’ve tried and that doesn’t work even with 365. But if you haven’t tried it in the past 12 months, I’d suggest giving it a new chance.