I've been a Joplin user for years, looked at Trilium once or twice, but the complexity and (iirc) database-backed storage kinda kept me away. The latter also always slightly irked me about Joplin, but at least you can export the whole notebook to markdown.
Which I did, when Joplin declared slop contributions OK (and a bunch of plugins were also on the slop teat, and you kind of need plugins). Then I started up SilverBullet and I haven't looked back.
In terms of "I want an alternative for Obsidian" I think it might actually come closest.
