There appears to be a bug in Mountain Lion where Cmd click on a spotlight search result doesn’t bring up a Finder window. The “Show All in Finder” option doesn’t work either.
A workaround is to restart appleeventsd
(by sending a SIGKILL).
Source: http://d43.me/blog/1511/show-in-finder-not-working-in-mountain-lion