That’s right - I’m not sure the format, and their markdown export is honestly pretty garbage. Though Logseq I believe is moving to a db type infrastructure as well though you will always have the choice to store in plaintext.
I prefer Anytype to Obsdiain, and I prefer Logseq to both, though primarily because logseq has transclusion support and anytype doesn’t appear to be putting that in their priorities. If transclusion isn’t important to you, Anytype is really great. It has a OOP kinda philosophy where everything is a type or a relation between types. And each type can have several templates - let’s say I create a type called journal. I can make several templates - a daily journal, a meditation journal, a therapy journal, etc. Then I can use sets and inline sets to show all journal entries of a particular type.
Speaking of Journals, I prefer how logseq handles it, with daily notes and a daily note template. I still have main repositories of notes, which I embed in my daily note template, and then I have my daily musings for just quick notes and stuff. I also have a page that queries all of the daily musings from all of my daily journals - essentially extracting the more fleeting stuff from my daily notes.
I recommend also looking at SiYuan.
Though in terms of price, Anytype is currently king as it’s completely free