I have worked with PzDB for several years now. It works fine and can quickly find almost anything and has enough filtering possiblities to narrow down your selection. You then drag and drop it into Poser

You can use the default keywording or add your own if you feel the need to do so. And yes, it is PC only, but it works with P7 upwards (I believe)

About categorization: PzDB does not look into your materials, so if it is not named properly, it will still not be found - unless you add the proper keyword to it (such as the type/name of the material).