This feature is at about the right spot for me. It is still convenient enough for me to run software I want that isn't signed, but sufficiently obtuse that neither of my parents have figured it out. Given they are both prone to running any executable that any website tells them to download and run, this feature has probably save me several dozen hours of fixing their computers.
My answer to that was chromebooks.
Currently most desktop management structures try to do it backwards by taking an OS, i.e. macOS or Windows, and then trying to glue restrictions on top of it which always leaves holes or undesired side-effects.
The best 'middle of the road' so far seems to be active monitoring with Apple's or Microsoft's native management tools or with stuff like OSQuery; it also tends to be less intrusive for people that are convinced they are 'better than average' (nobody is) and don't need to have an MDM babysitting them.
But even then, there will always be people thinking their personal preference definitely means the big bad corp did it wrong or their personal need is more important than trying to do something about the constant barrage or crap any machine faces during its lifetime.
For the home user, all bets are off.