I use this tool everyday and with some customization it has been very helpful for me. It helps that I also use VS Code for my job so its nothing to have an extra window open. I don't have to worry about folder and file structure and just write. The VS Code search is robust and fast.
The customizations I use are just for auto creating daily notes and including timestamps and other metadata.
Foam is also easily incorporated into static sites, although I have not yet used that feature.