Comment by illwrks
Have you inadvertently set the search privacy on your drive? https://support.apple.com/en-gb/guide/mac-help/mchl1bb43b84/...
If that's not the issue try rebuilding your Spotlight search index: https://support.apple.com/en-gb/102321
No, Spotlight has just been broken for several years. Thankfully Tahoe seems to have improved it a bit for me.