I'm assuming it has to be different teams that don't talk to each other doing quests direction and writing. Look at hangouts. Started off ok with Noelle and Barbie, but then they gave us Diona/Benny/Chongus. Who in the hell thought that those characters are the ones that people wanted to hang out with? Top "husbando" people are clamoring for Zhongli/Childe/Albedo/Xiao, for everyone else, you could pick any waifu. But no, we get one of the children and 2 of the characters that fell into neither category.
Now for the next round - like 4 months later, we get another child (Sayu) and Thoma. I guess people will at least be happy about Thoma though. Then you have to wonder if they're using hangouts only for 4* characters, since the 5*s generally get their own category of quests. But to me, that doesn't feel like they're the same thing. The hangouts are like dating sims or at least "choose your adventure" stories. The 5* character stories are more for building lore and expanding the background of the characters.
The narrative quality and quest types feel almost drawn out of a hat. Look at that Reconciling Stars event. Out of nowhere, it came in, introduced new characters, gave a ton of useful world lore that you couldn't get anywhere else, and it was limited time, disappeared, never mentioned again. To me, that feels like it should be added to Mona or Fischl's story quests for posterity. Then Ganyu's story quest was just basically exterminating some low level enemies while she complained about not fitting in. Worthless for the most part. Zhongli's story quests - some of the best and most interesting in the game. Then, we have an interesting quest to unlock the Teapot, charming quest with Yanfei, and then she disappears from Liyue entirely, not even in background promotional art like Xinyan. Eula quest - everybody's talkin' bout Eula. After Eula's quest - not even an NPC mention anywhere in Mondstadt that she exists.
I think they need to gather everyone into a room, draw out a map of what types of quests they create, which characters have them, and fill in some blanks across the board. I don't need Sayu hangouts. How about we get Keqing's first quest? Stuff like that.