I have encountered this issue before when I tried using Obsidian my RPG pdf collection (10,000s of files), would not recommend. I do still like Obsidian and will keep using it, but would something like Trillium work as a sort of PDF library software for a massive amount of files like that? The main need is to be able sort/categorize game systems using tags, link to pdfs, and maybe have some sort of Dataview-esque query capabilities. Zotero is the least worst option, but it still has some annoyances for me and I’ve still been looking for something that could help me organize better. I know this is billed as a note-taking app, so it’s a weird use-case, but Obsidian was pretty close to being a decent solution, if not for the slow speed issues.
These are apparently called “Desire Paths”
https://en.m.wikipedia.org/wiki/Desire_path