Obviously as mods we have to balance curation of the content on the site with the curation of the community on the site.
However, all the tried and true SE best practices - about Q&A in general, about community wiki, about Good Subjective/Bad Subjective, about scoping - are all completely on point for this site. No SE site is really 'different' from the others. Everyone who starts a new one thinks it is. We thought ours was. Then after a year plus of curating it, we realized the wisdom of the system. This SE will be run as a Stack Exchange. It is for experts who have actionable questions or problems they need an answer to or help with. That's not really a very strict format, but clearly some things lie outside it and don't belong here. In most cases, marginal questions can be brought back into the fold, because unless they are someone starting a question just for rep or to see themselves talk, there is an actual problem or question they have underlying it, they just aren't stating it in an actionable way. In those cases, we close the question and people pitch in to make the question answerable and then it gets reopened.
We generally wait to see some community closes before we mod-close, unless something's clearly spam or egregious, because it makes people feel better. But that's not a rule. We don't have rules, except the cardinal rule of "Don't be a dick," we just have guidelines and rep-driven community empowerment and experienced mods. So in general we try to wait for community closes, in general we try to leave an explanation on the closed Q that explains why and how to fix it up, in general we try to help with that process. But don't always have the time to do all that ourselves, so the community may feel free to jump in!
I will note that we have gotten "not constructive" flags on that question, which you don't see but the mods do, even since the reopen. But one person pulls the trigger, so everyone always thinks it's "one mod!" or "the modclique!" or whatever closing their question; there's usually a lot more behind it than that and that's why the mods are all established members of the community that folks should have the sense to trust some.
Reviewing our stats, over the life of the site (2200 questions) about 100 have been mod-closed. Less than 5%; I think that makes it pretty clear that there's not a heavy hand or too-strict rules. (It actually makes me think we've let too much slide...)
In the end, the community we want is a community that is motivated by high quality content and by expert Q&A. If we have discussiony stuff around, sure it might bring in "more" users but not the right ones. If people come here and see Yahoo Answers quality stuff, the numbers might get bigger but the experts will flee. Newbies might flee, but ideally those with fire in their bellies will want to come/stay to become experts. And that's the SE value prop.
You're a valuable expert on the site; you've asked many questions and gotten many answers. If one (temporary) question close is depressing you, likely the right solution is not RPG.SE process change, it's to get out this weekend and have some fun. I'm not saying this to be mean; I know what it's like for one forum post or email or SE question to get under my skin. But when one steps back to get some perspective, life goes on.