You’ve already answered your own questions in the “Some Solutions” section. If you completely lose your password to your vault there is nothing you can do, simple as that. Don’t lose it.
Cloud-based sync is incredibly easy with self-hosted cloud, as pointed out by the KeePassXC FAQ. Self-hosted cloud is effectively a local solution.