Before Dehya is kinda rough
All the launch story quest (Amber, Diluc, Jean, Kaeya, Klee, Lisa, Razer, Venti, Xiangling, Xingqiu, Mona): All pretty mid and forgettable outside of the Venti one which was solid. They are all carried hard by the game being new and fresh so most of us were still in the honeymoon period
Tartaglia: okay
Zhongli 1: Pretty good. Early on the Archon story quests were the only ones you could (for the most part) expect to be at least decent
Albedo: I can't remember anything about this one and what I do remember is probably from the limited event that was around the same time. At the time I remember thinking the event story should have been his story quest lol
Ganyu: Awful
Xiao: Think it was okay?
Hu Tao: Okay at the time
Zhongli 2: Pretty good
Eula: Pretty annoying how one note Eula felt after this and it took years of events to redeem that character for me lol
Ayaka: Forced to do this in the middle of the archon quest to pad it out cause the archon quest itself was lacking made the whole thing feel like filler
Yoimiya: Similar situation but yoimiya herself carried it by being a likable character
Raiden 1: Pretty bad
Kokomi: Awful
Yae Miko: I remember this one being decent? I remember Yae got flak for being kinda an asshole but it was refreshing to me after all the white bread ass characters up to now
Ayato: literal who character that had no relevance in the main story that was suddenly shoe-horned in after the fact? Yeah this quest wasn't very good lol
Yelan: Decent
Kazuha: Kinda boring and another character that had better story quest in limited event stories lol
Tighnari: Very good
Cyno 1: Mid
Nilou: As far as low stakes quests goes, I think this one is pretty solid
Nahida 1: Solid
Alhaitham: Mid
Other characters had pseudo story quests in the form of Archon Interludes like Shenhe and those are pretty good