It depends on the mod. The Hall of Fame mod for Civ4, also used by the Game of the Month, is widely used because you need it to participate. There are many Civ4 players that will not play without it now that they have used it and are used to it.
In Civ6 Game of the Month, players are always asking if we will let them use the UI Mods. We have been begging for the Civ6 .dll to be released for a long time because we cannot have a real game competition without it.
It's also essential, as Leif said, to allow proper competitive play like Hall of Fame or GOTM where we know everyone is playing on the same code base and not cheating!
Sure, I hear you both. My point wasn't to say that mods are unimportant (I myself couldn't enjoy Civ games nearly as much without mods!). I was just giving my POV to
@AntSou 's question about whether VP affected Civ 6 sales. While many people here (civ
fanatics 
) may use mods, I still contend that among the entire userbase, mod users are a minority, and so the number of people sticking to V solely because of VP and therefore not buying Civ 6 seems likely to be a minority.
So as member of community you do not "not want it", but also you "don't need it".
In the context of my first answer ("no demand for it"), that's exactly the same thing.
Let's be accurate in what we're talking about. You said specifically that we other modders "
simply don't want the source code". That's what I was directly responding to, not "no demand for it." I hope this clarifies the point for you.
Worst, not being "against it" while opposing "we don't need it" to article about civ6 modding future seems to be incoherent in my mind, or at least equivalent to "not want it".
Well, again you're misrepresenting or misinterpreting the thrust of my argument: no one said "we're not against it" as if we'd only begrudgingly accept it. I clearly said we'd all like to have it. Why wouldn't we? More tools and more possibilities are better. So now amending your above statement accurately, we have "we'd like it" and "we don't necessarily need it [to accomplish what our modding goals are]" - these are not incongruous feelings.
I get that you are emotionally invested in having the DLL - you 100% adopted the mantle when you broadcasted your feelings and frustration in-game to all of your YNAMP subscribers (by far the most popular Civ 6 mod ever and currently sitting at nearly 1,000,000 subscribers). But because of this, you've indicated that you feel as if you're standing alone or that others are against you, when that isn't the case at all: you are clearly the most vocal advocate for the DLL so I don't know what your expectation is.
Just because
for my own modding or for
my own enjoyment of mods I'm not dying for the DLL (and rationally do not expect it at this point given Firaxis's messaging) doesn't mean that I or any other modder is against you or wouldn't
appreciate having the DLL. But I think the popular sentiment among players who use mods (but do not make mods) being that "the DLL will fix the game" is shortsighted for multiple reasons, and you have played a huge part in actively cultivating that sentiment.
I don't want enormous gamechanging mods and I didn't personally enjoy Vox Populi. For
my taste, mods like that tend to bloat the game, but of course many others love it, which is great. For
my own skill, I do not know C+ and I don't care to learn it and then figure it out in the context of Civ 6 modding because my free time is limited and I can already accomplish nearly everything that
I personally want to without the DLL. Also as
@sukritact said, DLL mods have big compatibility issues which would also be a concern for me if I were making DLL mods. I'm allowed to feel this way without it being an attack on you.
Yes, having the DLL available would give other ancillary benefits aside from mods themselves as you've pointed out, but those are "nice to haves" - not utterly gamechanging.