Urriak Uruk
Gaming is fun, and fun is for everyone
Yeah, I mean, he's not wrong. Look at something like Dragon Heist. A very, VERY different module from, say, Princes of the Apocalypse. And, some very polarizing views of Dragon Heist. You'll see people absolutely loathe this module. It's the worst thing in the world. OTOH, others like it and have a good time with it. It was certainly popular enough saleswise that there's probably a fairly big selection of people who played it. And, judging from the additions to it on things like DM's Guild or Reddit, it certainly wasn't universally hated.
But, I wonder how much of how people judge the module is based on their own group. I have a sneaking suspicion that a large part of what people think about a product is based heavily on the group that that person plays with. We especially saw this in the 4e days when you had a game that was strongly based around the idea that you would be playing with strangers and people with stable groups really reacting very negatively to that. Not because it was bad per se, but, because the solutions the game was offering were to problems they were never seeing.
The interesting thing about Colville's video is that he is indeed, very very correct... but it's also not a super illuminating take? It largely boils down to "each table is different, so a lot of the rules aren't universally useful." Which I think everyone knows.
I guess the most important point (and it's implied in the title) is that when talking about D&D you need to mention the context. So if you give a review of a module, you should say "Hey it worked for my table, which is made up of these players who..."