There's already a pretty solid key management system with the recovery account system + master password so if you are not technical enough you don't have to rely on all the keys (even though it's a risky ordeal)
"Maybe we could design an automated system for direct management of keys"
I think you're referring to authorizations which allow another account to act on te account's behalf.
At the end of the day I think this problem (which most blockchain face) is more of an education issue than a technological one. At the end of the days some users can't really be trusted with self custody and would be better off giving their keys to a third party that manages it with regular web2 systems eg: a google account.
You can do some pretty clever things to prevent the "key holder just steals your money" with multisig but it'll never be as secure as self custody so that's risk that users have to be willing to take. One could argue that it's better than your grandma losing their keys that they wrote on a piece of paper and thus access to the entire account.
My point being, the tech is good enough at this point and that problem falls more on wallets devs than on core devs
RE: Core dev meeting #70