For people who keep a lot of notes over time: what actually gets harder once your note collection grows?

I’m not really asking which tool is best. I’m more interested in the failure modes.

For example: • capture is easy, but organizing later becomes heavy • search works, but reusing information in context is awkward • one note ends up belonging to multiple places • structure helps at first, then becomes overhead

If you’ve used tools like Obsidian, Notion, Logseq, Apple Notes, or plain Markdown for a while, what started to feel limiting for you?