You've touched on the real tension in modern authentication philosophies...
At the enterprise level, companies want people using as few passwords as possible (because passwords can be shared / leaked), MFA, or better, SSO everywhere. Central revocability is essential, and when people inevitably get locked out, there's a service desk to fix that promptly. Even in the worst case of being laid off and locked out in the AM... I couldn't care less about the actual contents of my work email outside the need to get the job done, so good luck to my manager figuring out my filing system, and good riddance.
Privately, most people are better off if you reverse almost every aspect of "enterprise". The biggest risk to my boring ol' GMail account isn't being hacked, it's forgetting the password or losing access to my MFA device (usually a phone, which unsurprisingly enough, most people change every few years) - And $Deity help us if we've forgotten the credentials to that throwaway recovery email account made 15 years ago. "Support" does not exist beyond arguing with a bot that has no path to an unlock unless you magically remember everything that led to being locked out in the first place.
There is no technological way to reconcile those two needs, they're diametrically opposed. Humans want short, simple passwords and easy ways to reset them; companies want complexity and control. And there's nothing wrong with that until the likes of Google and Microsoft start treating the public like enterprise customers.