For this to even make sense, they would need to also add support for creating/adding cutscenes and voice acting. Having now dungeons filled only with monsters, where the story is solely told by dialogues and/or lorebooks would be jarring. The problem is, that even if they do this, there is no modder or group of modders who will have resources to pull off cinematics and voiceovers on the level of original BG3. And even if we do get modded cutscenes, these will be screaming "mod content" (and people will be complaining anyway to someone).
That's why I think this mod support will be focused on gameplay features and/or UI, not on adding now story content. But we'll see, Larian proved they can reach high, so who knows what they are cooking for us.
I have a lot of trust in modders. However if no new content would be possible to make, the interest in the game might wane. I currently already have all mods I need for normal gameplay (and I would not play the game without mods) but I would really appreciate the creation of new environments. The best part of the whole game for me was exploring Shar's gauntlet and I hope for additional "simple" dungeon crawler content. I would not mind if scenarios made by modders hadn't less or no cutscenes, and voice acting is nice but not mandatory. I want some adventures where you look for treasures or the lost person or ..., without the necessity to constantly save the world.