I do pretty much the same as Mike on Lightroom (LR) but for stills. As Mike has written in another post, aside from being an excellent image editor, LR is a tremendous database which is highly customisable.
Whilst the idea might sound a bit daunting initially, it's a pretty intuitive program ( and certainly compared to Photoshop) and with a little discipline when importing images/video, as Mike explains, they become pretty easy to find at a later date. You can search and find items in all sorts of ways: which camera did I use; which lens; which date; where was I; through keywords.
I know there are members who grumble about the relatively new subscription approach and cost, but I've been using the program since it was first released and it has just gets better and better at, I would argue, not unreasonable cost for what it provides.