I do not know if this is the sort of thing you are after, but as a photographer it is absolutely essential to me to be able to find pictures from keywords.
I have set up the Windows search on my image folders to index all the metadata etc.
I then use a small VB program on a button or context menu to plug search criteria into the appropriate search field in the Opus interface.
For example I could make a search of my Weddings folder for “Dress” and bridal bouquet" and “best man”; or even “Dress” OR bridal bouquet OR “best man”. etc etc.
You need to know the SQL rules about Windows search, as there are some restrictions, but in general use it is absolutely fine and works like lightning.
It is an idea you could easily adapt to your own needs, perhaps.