I do configure Finder to start its search in the current folder because that is usually where I want to start searching for a file and I want to limit the number of possible false positives. It’s easy to expand the search if needed.
I have heard of people who force Spotlight to reindex their drive if they are having trouble with getting results. Have you tried doing that?
I normally run spotlight from the looking glass icon in the menu bar so there is no 'current folder'. What happens is that it turns up a whole ton of XML files, dat file etc instead of the files I'm looking for. They appear only later and at the end.
In the beginning it had much more sense to keep that stuff out. And yeah I can exclude folders but I don't really want to have to micromanage that stuff. The whole point of Spotlight was not having to do that.
Windows 7 also had a fantastic search mechanism in its Start Menu (although it came 4 years after Tiger's Spotlight) that has since been broken in Windows 8 and 10 for reasons unknown.