Something similar to what you described has been proposed (if I'm not wrong by Pablo) in a not yet merged NIP that focus on keys rotation.

For a good sign pattern, NIP-46 is the solution, https://nsec.app is a very interesting implementation totally non custodial. I use also Gossip on desktop as signer.

https://github.com/fiatjaf/window.nostr.js permits to use NIP-46 on every site that has NIP-07 (extension) support, also via bookmarklet.