For me, as a happy amateur, the solution is simplicity.
I only use a few keywords which I assign to my scanned images in Bridge. These keywords are for important persons in my family, kamera/lens/film used, development info, location. I don't use keywords for events because I create subfolders (in annual folders) for the events.
For generic type of images, by which I mean things like macro, skies and even street photo, I have separate folders (ie not annualised) where I put all images of the genre. T
The sort order is date-numerical because I assign file names to all scanned images according to a year-number convention I've devised: year-roll number that year(total number of rolls)-scanner-camera-film_frame number, ex 2013-89(312)-9k-TTL-3X. This number is also put on the negative sleeves of course.
This may seem unorganised but works for me. So far I've not been unable to find a frame I've looked for.