I'm glad I'm not the only one who has bounced around between note apps with varied success. I too have settled mostly on Obsidian, especially for work. The Markdown support is excellent and I am finding some useful plugins.
I do still use a mix of Apple Notes and Standard Notes for personal note taking. As the author mentioned, using Obsidian for both personal and work feels a bit cumbersome - especially in my case since I can't use the same Google Drive for both due to corporate policy.