I think notion’s big failure is how slow it is. I prefer the features of Notion, but end up sticking with Obsidian, because it has such strong performance.
I like Obsidian. I prefer it to notion too. I think like Obsidian. But, there has to be a more aesthetic option than Obsidian that does not involve Notion's online and therefore limiting and slow database architecture.
I'm partial to Obsidian's stock aesthetics, but if you prefer the notion look there are plugins like make.md and hundreds of themes.