I used to use the precursor to Photo Supreme, which is IDImager.
When IDImager support was ceased, and Photo Supreme was the update path, after a trial, I removed it from my PC as it didn't seem to be as good(or flexible) or stable.
On updating to Win10, I never installed IDImager.
In the final few months of using Win7, and searching for all manner of cataloging software I eventually settled on Windows (free) Photo Gallery.
Reason was simply because it synced perfectly with my tagging software which was ViewNX2.
All tags are entered into NEF files in ViewNX2.
The issue was that very few, if any, other cataloging/tagging software would recognize the VNX2 tags, and vice-versa.
So in trying to maintain cohesion and a continuum(of my primary tagging method), about the only real option was Windows Photo Gallery.
The only point to note is that it's reliant on the Nikon NEF codec to be installed on Windows.
The the side benefits are that tags can be viewed/edited/added directly via Windows Explorer directly into the NEF file.
My long term plan is to acquire a proper open source Db setup as Bjørn has commented upon numerous times.
But until I can find a reasonably priced solution, or acquire the knowledge to build it all myself, I'm happy using the most humble of such software .. Windows Photo Gallery.
Very few tagging/cataloging software can actually embed the data directly into a raw file(which is important to me)
In essence I agree with Jørgen, in that Lr's cataloging is more advanced than some, it's not as advanced as it could be(re IDImager), and it's a closed system.
If all I wanted to do was find a photo of Mum from my archive(on a specific drive) .. if I had to use Lr, that process would take a few minutes at least.
In my current setup, I open a drive in Windows Explorer, type in Mumin the search field and my (tagged)images are all listed .... in whatever order I select.
The other handy aspect of using the humble Windows Photo Gallery, is that bulk adding/editing of keywords is the most simple method I've yet had to use.