Hacker News Reader

Isn’t there a plug-in database where all sorts of folks have created effects, automations, etc?

Reaper Stash is probably what you're thinking of, stash.reaper.fm, and it has its own package manager, ReaPack that helps manage all that.

It also has a comprehensive API that can be manipulated with Lua.