How to always allow any app to do anything / disable Security & Privacy authorization dialogues
The only solution that I know of is to approach the problem from another direction.
Writing all of your own Automator apps (which are going to continually run into this problem), and trying to find loopholes to make them work? That's going to be a losing battle.
You might be able to solve this with SD Notary: Notarizing Made Easy from the folks who make Script Debugger. Honestly, I don't know, but it might be worth checking out.
What I would be doing is using Keyboard Maestro to handle the automation. Once Keyboard Maestro has been given the proper authorizations, it can handle any of these situations (I presume, since you don't give specifics, I can't say 100%).
Then you will have one centralized place where you can control and manage all of these various automation actions, as well as a community where you can ask for help as you learn the ropes.

macOS should have a power user mode.

I agree wholeheartedly. 100%. No doubt.
But it doesn't, and I suspect it is very unlikely to add one.
That being said, I think Keyboard Maestro is the closest you can get to a Power User Mode on the Mac. No, it's not from Apple (I doubt they could make anything as good), but I'm not aware of anything that will give you more power and flexibility.
(Non-Disclaimer: I'm just a user of the app. I don't get paid, compensated, rewarded, or anything else in exchange for my endorsement and recommendation. I just happily give the developer my money whenever a new version comes out.)