I think for some people it's probably pretty great, or for storing not-website-passwords it's probably also good, though there are probably simpler to manage tools for "terminal/server" use like `pass`.
strongbox has pretty intelligent support for maintaining a cached copy, and the sync support has always worked as expected for me there. The keepass format does store last-changed date so it is relatively trivially possible to synchronize a database (assuming you can decrypt/open it ofc).
if you need it on the go, VPN tunnel back, or again, Strongbox has good native support for dropbox sync or onedrive etc, can't specifically vouch for it but Strongbox seems pretty competent.
Guess modifying the database on 2 different machines simultaneously might cause a conflict, never tested it though.