I moved from LastPass to BitWarden when LastPass nerfed their free option. It was easy to migrate my passwords over, and it's mostly the same workflow. BitWarden has the most full-featured free plan, and it's open-source, so if they did change their pricing model, you could self-host if you really wanted to.
KeePass is the other notable free option, which does pretty much what
@snic describes. It is open-source and self-hosted although extensions exist that make it easier. You don't need to be a software engineer to use KeePass, but it's not quite as idiot-proof as the other options.
I don't see a ton of differentiation between the paid options that are out there in either features, security, or usability. So pick what you like and are willing to pay for.
Any password manager that you use will be safer than not using one. I prefer a dedicated solution over the built-in ones (like Google). A dedicated one will make your passwords more portable, and at least in the past, if someone gained access to your machine, it wasn't terribly hard to scrape the passwords from the built-in solutions.