How to open a searched file in Finder?
Highlight the result in Spotlight, then press ⌘↩︎. This will open the containing folder in Finder.



Alfred will also let you do this, with a bit more customisation: