You might want to try and use the excellent freeware product EasyFind. It has been around a while, lets you put in exactly what you want to search for, and is fast.
I have easy find for years, use it in tight jams every year or two.
I find EasyFind to be easily fast enough. That is one reason why I prefer it over Spotlight. It has always served me well.
This morning, I type in an easy search and Spotlight just sits there. Nothing happens. At least Easy find the gears start turning. And Spotlight got the full index done.
We have quite different experiences.
With the mentions of EasyFind I recalled that I once tried it but didn't recall why I don't still use it....so I downloaded the latest version and gave it a whirl.
I typed in a single name, specified "File Contents", tried all the Operators while asking it to Ignore Case. EasyFind found nothing.
I popped the same name into Spotlight and immediately got:
4 documents
8 messages
1 contact
4 PDFs
10 web pages
1 spreadsheet
2 web searches
I'll be sticking with Spotlight.