I love Hook. I don’t like that there is no way to know that a file in the filesystem or in DEVONthink or anywhere else has an active Hook relationship. Hook claims it creates a “mesh” of documents and other digital assets, but unless the thought comes to mind “I wonder if this file (or whatever) has a Hook relationship” there’s no clue just what that “mesh” comprises. That to me is a major roadblock to using Hook for what you want – managing files and documents. So, I only use it casually.
That said, I guess I’d wonder just what your definition of “manage” or “keep track of” document is? Is it simple hierarchical storage? Naming conventions? Discovery (finding things with automation, smart groups, visual maps)? All, none, or something different from these? Maybe before shopping around further you might want to take a blank sheet of paper and write down your requirements and specifications for “manage”, and then do your own Consumer Reports matrix of “meets” “does not meet” requirements. A little formal analysis can go a long way to solving problems like this.
You’re consulting with a client – yourself – so write up a formal analysis or story treatment that the client can understand and buy or reject. (“What’s the best way to manage my stuff” is NP-complete – you can test answers but you cannot solve the problem without testing.)
Personally: for me I’m sticking with DEVONthink. I have multiple databases – family stuff; individual work and personal projects; and a small database I use for syncing to iOS/iPadOS DEVONthink to Go because I don’t need to ship all my freight back and forth to cloud-cuckoo-land just to use the handful of things I need to be mobile.
I also use cold storage for documents that just need to be someplace but don’t need to be referenced much. Cold storage is mainly ~/Documents and subfolders. Things like financial records go here, manuals, business files, etc. I’ve never stored bank/credit statements, employer stubs, tax records, etc., in DEVONthink because after tax season who needs that stuff? In other words, cold storage is for things at that best I’d need to see a couple times a year. A lot of gigabytes fall into that category. I don’t use DEVONthink for photos and videos – though some do – because it sucks as a DAM.