I recently went through this effort and I'd say it's worth it. In particular, I've used the "Self-hosted LiveSync" plug-in + docker.io/oleduc/docker-obsidian-livesync-couchdb, and I setup all my infrastructure within a VPN (with Tailscale, this was pain-free).

I knew about using just git, but having Windows, Linux, macOS, iOS and Android, it was just way easier to use this solution instead of fighting with git-like apps for each OS.