Using any password manager at all is the most important part. Once you are, you get two main benefits - password uniqueness and password strength.

Uniqueness is important because when one site gets hacked, they're immediately going to try your email/pw combo on every other site in the world, and if you re-use passwords, you've just instantly lost multiple accounts at once. Unique passwords means you don't have that problem.

Strength is obvious, but using a manager means you can go really hard on strength and still not ever have to remember it.

You then only have to remember one strong pw for your manager account and then that's it forever.

Bitwarden is my favorite manager, and it's got a great self-hosted setup with Vaultwarden, but also their regular free plan is good enough for most people and the paid account is pretty cheap if you need multiple organizations. Has passkey and TOTP and everything else you'd expect these days too. Decent mobile apps and browser extensions.

But yeah honestly as long as you are using a password manager at all, that's the most important part. They're also usually pretty easy to migrate between if you want to try other ones out.