When you type something in spotlight, highlight a result and hit Command+Enter, it should open the containing folder in finder (For reference). However, it does not work on my OSX 10.8.2 MBPR. The finder application comes to the foreground (the finder menu bar is shown on top of the screen), but no finder window on the location gets opened.
I have BetterTouchTool installed and thought this could cause it somehow, but, having it deactivated, keeps happening.
Best Answer
There is a bug in 10.8.2 that intermittently makes revealing files in Finder stop working. When that happens, Archive Utility also stops responding whenever you try to extract archives.
As a workaround, you can terminate the appleeventsd process from Activity Monitor or with
sudo killall -kill appleeventsd(without -kill the process is sent a TERM signal and other processes stop responding). The issue will probably return in a few days or hours though.