>I spent months trying to figure out how to make it work for me before realizing it has zero library management functionality
It would help if you specify what you mean by library management. What it doesn't do, and is very clear, is handle things like renaming files. You are expected to have copied the files over to your hard drive and organized them into folders (in any way that you like).
Beyond that, it serves library management well enough. You import a folder, and it becomes a collection. You can tag it, do queries, etc. It works very well for me when I want to find all photos of, say, my cat - even though they are spread across many directories.
Why would you have to spend months to figure that out