I'm not an average gamer, I'm a mod author myself and I have some trouble to install some mods.
For instance, I was never able to trust SPID. In 2020 I attempted to use a similar mod, which distributed armors and weapons through scripts, and ended up with several npcs naked, as it made no distinction between the sexes. So I created OBIS Armors, which inserted a new level of lists between the outfit and the vanilla lists, and then modified several armor plugins by hand, inserting them manually and using bashed patches to solve conflicts. It worked. Then later came SPID and it became a sensation, but every time I tried to use it, with some other mod that requires it (for instance, for spells), I ended up with crashes. And when I point it out, I'm told the problem is on my end. But my load order have no issues since 2021.
Other example is MCO and animation mods. Can't install any of them, because they require Nemesis. And Nemesis can only get compatible with FNIS through a fake plugin. This plugin removes the shield arm fix from FNIS. I reported this on their github years ago, no solution came. Still Nemesis is a sensation on the scene and hundreds of mods depends on it. Can't make any of them work and from my perspective, they are extremely niche mods. In 2021 I collected some animations as resources and made my own DAR setup, using a combo of 4 blows for each weapon. But I still see hundreds of these mods dumped on the site from time to time, and their requirements are growing larger.
This is all the consequence of parlor modding. It is another aspect of it (besides the suppression of province-level content), where mod authors are cloistered in small overspecialized cliques, and these cliques dont communicate with each another. This ended up with many authors isolated in discord channels, with their own following. Hence their mods become incompatible, and inaccessible to many. So it is not just a average gamer problem. It is a problem caused by a worldview that does not allow peaceful coexistence between the authors. Hence why it is more easy to find parlor dramas (and usually over follower mods), than to find mods that are compatible with your setup and can be installed easily.