I don't think it's especially great at note taking. I'd prefer a different directory structure for that.

The love for it makes more sense if you think of it as a really simple website builder. You can have a database of pages with structured data, unstructured data, and nice layout. That sounds simple, but it covers a lot of use cases.

If you check out communities talking about Notion, you'll see the layout stuff is huge. You might even think it's overboard, to the point of productivity porn. But if you're the kind of person who cares about that (think the girl in middle school who took notes with 6 colored pens) or you want to make something pleasing to use for a tiny organization, you can end up falling in love with it.