vaultwarden is a free Rust-based implementation of Bitwarden that works with the Bitwarden client. Password Store (pass) is also a great password manager with multiple clients and frontends.
Yea but for non-techie users the cloud based storage the majority of the value proposition. I'm going to be setting up a password manager for my mother shortly (since she's trying to get to grips with a ring binder full of passwords my dad left behind) and cloud based storage is a hard requirement for whatever software I end up choosing. Some other big features are no timeout auto-lock and the ability to assist with recovery codes remotely (in case she locks herself out of the system).
Edited to add: I would mention that I personally use KeePass and love it to death though - my SO and I have vaults we occasionally sync and it's a wonderfully simple and easy to use application for anyone with confidence in keeping the password vault secured and a backup ready.
I would think cloud storage of some kind is default in the current devices. I use dropbox as storage for DB file and it autosync with other PC and phones. Also you can get access to file in browser if needed. Google drive might be even better for it.