The closest approximation to a solution that I've seen is the budget/allowance feature on Alby. Basically once you've authorized the wallet to spend on a particular site, it will execute those spends upon a user's action without requesting explicit permission -- up until you hit the user's limit set for the site. I think this strikes a good balance between UX and security of a user's funds. There is still some risk, but at least it's hedged.