There are basically 3 different categories to choose from, depending on location of service and db: Local, "Cloud"/SaaS or selfhosted On-Premise.

For single user/home usage KeePass is fine or perhaps even the password manager included in web browsers. Using one of the SaaS options such as LastPass adds ease of access.

For company/enterprise usage sharing passwords in groups/teams should be supported and preferably an on-prem option.

• KeePass (Local), good choice and free
• PGP/pass (Local), cli
• LastPass (Cloud)
• 1Password (Cloud)
• Team Password Manager (On-prem), recommended
• Bitwarden (On-prem), dotnet/mssql docker stack
• Thycotic Secret Server supposedly also does "PAM"(?) (On-prem)