I have personally tried many alternatives (obsidian among them) but nothing comes close to what logseq offers _to me_, despite its few shortcomings (it's not a lightning fast implementation, it bugs sometimes).
Hope it helps.
FYI, as of last year, Joplin supports profiles on both Desktop and Android that are exactly that. Though you do have to restart the app to toggle between the two.
Release notes: https://joplinapp.org/news/20220606-release-2-8/
Open issue for multiple instances ala Firefox: https://github.com/laurent22/joplin/issues/591
Exactly my thoughts when I looked at it a few weeks ago (minus the privacy angle that I didn't feel).
I also bounced off the slew of influencer-type blog posts and videos that promise you that Logseq will change your {life, studies, PhD, work} forever when all I saw in those videos were very, very simple outlines. The whole community (including the subreddit) seems very... promotional.