In the last week, I've started using Foam too.
It hits the sweet spot for me:
- Plain Markdown files stored in git; exactly what I am used to for code.
- Editor is VisualStudioCode, which I always have open, and can configure however I like.
- No vendor lock-in.