USE A KEY FILE in addition to a password.
Your paranoid self can sleep well at night (as long as your key file is not being synced).
[1]: https://keepassxc.org/docs/KeePassXC_UserGuide.html#_databas...
Bitwarden is so much easier sadly.
Maybe it does help the fact that I have my NAS always online, and I treat my mobile devices mostly as "read-only" - i.e, if I have to create a new password it will almost surely be on my desktop / laptop.
Manual: All clients I've seen have the capability to merge databases. So you have one copy of the database in whatever online file storage service, plus each device will have its own local copy. Pull down the online db, do a bidirectional sync between the two databases, push back online.
Automatic: some clients natively support webdav, dropbox, etc as the master copy of the db file and will transparently do the change syncing for you.
https://www.ctrl.blog/entry/keepass-vs-bitwarden-server.html