Open the object location from find

Spotlight is good for finding things but for whatever reason lousy at telling you where those things are, as you have discovered.

But you can still do a spotlight search in the Finder. Just open a new Finder window and type your search term into the search field in the upper right side of the Finder window.

Once you have located the file/folder you want it will show the path to it at the bottom of the Finder window.

If you hold the ⌘ Command key down while clicking the mouse on the title bar (where it displays the path again) it will give you a pop-up menu that gives you a graphical hierarchy of exactly where that file/folder is.