If any apple product managers are reading this, the biggest thing holding MacOS back is that it global searches when you search a folder. I know there's a config setting for it, but dammit I want the default to be local file name search and full text search should be an off-by-default option, and search the whole hard drive should be a different also off by default option.
the one that does my head in is you can search for a file with spotlight but then the only thing you can do with the result is open it; you can't see what folder it's in or open the folder.
Hold down Command (or maybe Option), and it shows you the full file path in the bottom of the preview pane.