I personally use both a local password manager (KeepassXC) and a cloud based manager. The “critical credentials” as well as 2fa recovery codes and such go into the local vault. Critical passwords are for example the ones for mail providers, encryption keys for backups etc. which allow me to recover my accounts in an emergency. The rest goes into the cloud manager for convenience.