How to open items in the enclosing folder directly from a Spotlight search in macOS
The answer is simple: hold down Command and press the Return key or press Command-R. You can also hold down Command and double-click the item in the results list.
Spotlight has bugged me for years because I didn’t think I could do this. I never even thought to look it up. Dummy.