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.
Do you need that complexity? That's a personal question.