Personally own a MacBook Air 2017 that I use for pretty much everything. Agree with Lord Vile that a higher storage air is a better purchase than a base model pro. Both the office apps from Apple and the office suite from Microsoft work perfectly fine. I do prefer to open documents in the app they are created in; exporting and importing don't always play nicely with everything (SmartArt in Microsoft Office is a great example).
I don't really understand what you mean by 'missing a whackton of things'... I never had the idea that I couldn't do something. You might sometimes need a minute to figure out the 'Mac way' to do something, but there was never anything I completely couldn't do.