I’ve wanted to try BitWarden, but haven’t because I couldn’t find a way to use it as a standalone app without creating an account on its site or without having to self-host it. I prefer a solution that allows me to choose where to sync the password database.

Just run a bitwarden server locally, that's what I do.

Especially easy with bitwarden-rs or bitwarden-go (written in rust and go accordingly) instead of having to pull down the bitwarden blessed MS SQL stuff.

keepass?