Have you tried Dendron? I'm at the point where I'm debating if I want to migrate my workflow from vscode over to emacs so I can use org-roam in a combined notes/code/documents workflow, and both dendron and foam popped up in my searching for alternatives.

I'm curious if you had any preference or reason why you went with foam.

Dendron shut down a long time ago: https://github.com/dendronhq/dendron/discussions/3890 The repo is up, but the project is dead.

I wish somebody takes it up again. I'll keep using it for the foreseeable future because it's great, and haven't found better alternatives.