The fact that Notion’s search was so slow and not at all useful is part of what pushed me to Obsidian for knowledge management.
When you get past a certain number of notes, this becomes an issue. You might be trying to search for a concept you have a dedicated note of, but your search results are drowned out by normal usage of the word in other notes' contents.
Makes obsidian so much better.