Library management

So I found myself, quickly, with thousands of items in my library, Some I download and use right away, others I download because I'll need them later and they are on sale right now. Many ald older and do not have metadata on them. These are not in the Smart Content section. So how do I know I even have these anymore? By that I mean, if I am going through looking for something for a scene and trolling through outfits for my character or hair, or props, etc, I have to basically assume the smart content is useless and just use the Content Library section and pour through the alphabet until I find something I might have downloaded months ago.
How do people properly search things without metadata so they can find what they need when they don't know they even have it because they have too many items to memorize?
Comments
Some of us use a spreadsheet to keep track of what we have, and where to find it in Studio. Personally, I have never found Smart Content to be very "Smart".
I thought about that, but I need to see a thing to know if it'll work. Knowing what something is called isn't enough unless you use it all the time. This seems to the largest issue with victoria/michael 4 and lower.
You can also edit the metadata and add your own information like compatibilty, item type, etc.
that's what I was thinking, but not everything seems to track well.