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.
Press tab to bring up the preview pane in spotlight, then holding CMD brings up the folder it's in near the bottom. CMD+double click opens it in it's enclosing folder.