You can max out on discoverability and consistently, but the user ultimately will have to learn, through reading or experimentation, how to use the program.
Why would you think that is infeasible? Blender has even started improving on that front - after like 10 years of waiting it finally has tooltips!
In what way are tooltips "infeasible for advanced software"?
They aren't, and Blender has them. I think it's had them since I started using it, about three years ago I guess. Although they've definitely improved in that time.
Looks like proper tooltips were added in 2014. Blender was first released in 1998! 1998! 16 years to add tooltips!
I find it hard to believe that any UI theory says you can't have complex software that is intuitive, usable and discoverable without a manual. Link?
There is no conflict between usability and power. You can have very powerful interfaces that don't require a manual to use.