That and the related automation scripts. I would have thought that now that they introduced Javascript for Automation (similar to Applescript), it would be a lot more popular and would spur a lot of interest in creating workflows.

So far, I've not seen anything. I do use javascript for automation myself. A useful "trick" is to write Javascript using Script Editor, save the script as a .app file and place it in /Applications or similar and have Spotlight execute that Script. I've done things like Empty Trash, Lock Screen, launching a new Swift Playground (too many steps to do that with Xcode alone), quitting all foreground apps, etc. Almost makes Spotlight act like Alfred or Quicksilver.

I would really like to see what other people can come up.

One reason I don't like Automator so much is that it forces me think where to save the workflows I create. Automator has a very iTunes-like interface and I would expect that it takes care of organizing the created workflows. Actually, I think the Workflow app for iOS has nailed this down perfectly (together with integration of the workflows with the rest of the system).