I'm not opening a google drive document, but based on your TLDR, yes - key management on nostr has yet to be fully solved.

The best solution so far is nsecbunker (keys never leave the enclave).

Can you summarise the solution? Can't read the comments / replies as that requires a twatter account.