For text content, I'd be curious to hear your thoughts on the annotation features of the Jarvis plugin, which include tagging, summaries, re-titling of notes, and links to related notes. You can set it up with Ollama. I hope it might be useful, although I haven't tried it on such a large scale.
Other than annotation, you could use it, for example, to chat with your notes.