I use KeepassDX, one of the variants of Keepass. I don't know if it's any better or worse than the other variants but it has worked well for me so far.
The advantage is you are hosting your own password database so you aren't reliant on some cloud platform that inevitably gets hacked.
But a cloud platform is arguably more secure and has more resources for security than your personal database. True, you are a much smaller target and less likely to get targeted, but it still stands to reason that you are vulnerable.
Yeah I guess there's benefits to both. I do take security seriously enough so that if I do get hacked nothing of value comes out, such as encrypted file containers for important documents on my NAS that only get opened upon use.
I trust the 1,000 security engineers at AWS, for example, far more than I trust myself to build, maintain and harden a solution that needs to withstand an attack so heavy it could penetrate AWS or an equivalent.