After searching for an item in Spotlight, hitting `Return` will open the file, but hitting `Cmd` + `Return` will open a Finder window to the directory where that file lives.