The point about Google or apple or your passkey manager banning your account is a reason I'm still using random passwords in Keepassxc. I don't know if there is an open source passkey manager that syncs across devices that is self hostable.

Anyway, companies should be educating users more on passkeys, how they work and where they get stored.