IMO they're for completely different customers. Obsidian constrains itself to working on local text files that you can sync yourself. Notion is just another complex website where you turn over all your data and they sell you AI services.

The complexity is what makes it valuable to some people. Put simply, it does more than Obsidian.

Do you need that complexity? That's a personal question.