Also not a fan about the closed source thing, but I like about Obsidian that it’s all just markdown. If I ever need to ditch it, I can keep and use my existing files as they are.

Would this also be possible with Zettlr or Logseq?

I have no experience with terraform but Bitwarden has an API and CLI, so you might be able to script something with it?