> Genuine question, in what scenario is the self hosting setup and maintenance worth it?

Personal use. Using this avoids the potential of a bitwarden hack (see: LastPass) leaking out all your passwords. You are much less likely a target than a central server like bitwarden.