How do I add a moderator to a single space?

Solid breakdown. The only thing I would add is to back up before making the change — better safe than sorry.

Tried this on a staging copy first and it behaved exactly as described. Confident enough to roll it to production now.

One caveat for larger communities: keep an eye on the indexes. At a few thousand rows the difference is night and day.