You don't have to choose one or the other, it just takes time to make it right for both.
Word is a good example example. You want to type some text? It's easy. You want to format it? Click the icons that look relevant. You do it often? Keyboard shortcuts are available for everything. You want to do typesetting? Styles are available, but not enforced. You want to automate things? Integrated programming environment is waiting for you. And almost every action has its own page in the manual.
Simple things are simple, tooltips and icons provide discoverability, and you can head to the manual for expert content.
This is totally not how blender pre-2.8 works where the discoverability almost doesn't exist.
But I don't really know what the equivalent of "just type some text" would be in Blender.
I don't doubt Word is more discoverable, partly because of Microsoft's resources and partly because word processing is fundamentally more accessible than 3D modelling. But by the metrics you're talking about, Blender is maybe 75-90% as good. Which I don't think is the same as "discoverability almost doesn't exist".
I'd strongly dispute the "fundamentally" part, though this may only be obvious when using a VR-native 3D modelling program rather than a desktop one.
I’m not convinced that there is one.
To put another way, it probably takes a couple minutes to learn and be proficient in windows notepad, and a couple months to learn and be proficient in vim. However, for a task that may take a couple months in notepad, it might take a couple of minutes in vim.
I take beginner-friendly to be a more specific form of user-friendlyness. The usefulness of the concept is that it's common to see a UX and say it's not user-friendly, because it's not beginner-friendly. However, not all users are beginners. To someone that is proficient in both vim and notepad, vim is more user-friendly than notepad, because it is more friendly to him, the user, since it allows the completion of any task far easier.
Essentially it is about the path-of-resistance between you and your goal. A beginner friendly UI might do X, Y, and Z. But complex tasks like scheduling X, Y, and Z, automating them based on other events, or even performing them rapidly in sequence, are likely to be given a higher path of resistance.
You are confusing beginner friendly with user friendly.
User friendly UIs are most often terrible for experts and expert UIs often have some learning curve.
That said, I can not name a single application that has a better user interface than Blender. It is a masterpiece and I am in complete awe of whatever process and the people that created it.