This is an interesting question for me to mull over, especially since my taste when it comes to general reading material is pretty different than what I'm looking for out of a cRPG. I read constantly, so big walls of text don't intimidate me, but I'm just not a big fiction reader if I'm honest. I can read mythology or philosophy or a history that's dry as all hell, and it doesn't really need to justify itself, because the material is already implicitly relevant (it happened, which makes it inherently interesting) and I'll happily flip the pages on that stuff, but when it comes to poetry or novels or writing of that sort I'm just impossibly harsh in the judgement. Someone really needs to sell me on it so I can get it up for the experience, otherwise I tend to tune out at the first sign of weakness. Sure there are exceptions, like Tolkien or Howard I guess, but even there, the more I spend time with their backcatalogs or seeking out the real-world inspirations behind their fantasy constructions, the less enamored I find myself. I remember people telling me I should check out A Song of Ice and Fire, which I did, and read them all, but the whole time I totally felt like I was combing over a teleplay. Which I guess makes sense, since dude got his start writing for Beauty and the Beast with Linda Hamilton right? hehe. Anyhow, it didn't surprise me to find that I enjoyed the show more than the actual books. Heresy, doubtless lol. But when the actors are there to inhabit their roles, it becomes less about random new character X with a curious spelling to their name, and more about the person playing them for me. And so if that's like the high water mark in terms of fantasy 'story' than what are the odds I'm getting psyched for the more middling video game version of that? I mean I can barely get it up for Salvatore, who I appreciate more for the illustrations on the covers than the words on the page, so it's just a very tall order hehe.
Then again, that's not really what I need from a D&D/RPG game for it to nevertheless still work for me. Especially since my impression of Dungeon & Dragons has always been something of a B rate knock-off emulator, sort of invented to play the Lord of the Rings, but without needing the rights lol. The Forgotten Realms is replete with knock-off Lore, and I enjoy the kitchen sink aspect there, sure, but it's all rather silly at bedrock. So I don't really need it to be much more than a good cliché. I think where it runs into problems is when it tries so hard not to be cliché, a nice pastiche of clichés, and begins taking itself way too seriously - at which point I start head scratching.
And of course no amount of great story or perfect pacing will compensate for lackluster gameplay, so that could be another key factor for me. Like recognizing that the medium is just better at some things than others, and not setting the bar too crazy high for a narrative payoff. I agree with others that Planescape: Torment was pretty impressive, but even there the stuff that stuck with me was more the mood or general vibe or visual/soundscape ambiance, than the story per se. I played PoE too, but alas the setting just never hooked me. My critiques there would be no more insightful than my critiques of FR in general, except that it lacked the appeal and familiar continuity of a more firmly established setting. Being an original IP probably killed it in the cradle for me, since I just couldn't bring myself to care enough about Eora.
I think an RPG game with a middling or a derivative or a 'leans-heavily-on-allusions' type story, can still be pretty successful though, provided the gameplay is fun and especially if it offers a high degree of PC customization within it's admittedly well-trodden milieu. With that last I think the important thing is basically striking a balance between variety and aesthetic immersion. Not to make less work for the writers of the universe, but I really think they should hire a gang of modelers instead and go full bore into developing Char creation before it ever even gets there. Cause honestly, I can make a great story for myself about having a different face or a different get up and "wearing a black robe instead this time!" lol, which pound for pound probably delivers more replay value, than a cliffhanging in Chapter 4 ever would, but often times you don't even get that. It's the curmudgeon in me speaking now I can tell, but I'm still a little disappointed that the promise of 3d that Obsidian made way back when, when they assured us that the 3d model would supplant the 2d portrait in every way, that it still hasn't happened. I think for D&D cRPG what they should really do is pour a gang of loot into Face/Body models and then creating some sort of FIDM thing (Fashion Institute of Dungeon Mastery? lol) where the unarmored standard clothing appearance in Char creation is just absolutely nuts and decked out the nines. Instead of hiring VA actors to perform specific characters, just create some kind of massive library of PC/NPC everything barks, and get the theater peeps to wear the motion capture stuff to do all the Bruce Campbell expressions imaginable. Then get the writers to go to town! hehe. Like honestly, how is this medium ever to supplant the cinema as our highest and most revered art form, until we get the full range visuals going for the actors at least
I guess I am still just pining for the NWN3 choose my own adventure series that I never got. You know the one where we could make ISO style BG-esque campaigns for the single player to sustain it while the massively multi player live dm ghost writing aspect catches up. Still my big wish! NWN kinda failed for me on both the story and the gameplay front, but it had the germ of an excellent idea, before kinda forgetting what made the infinity gameplay with the full party so fun. Made something too Everquest-y in my view there, never actually delivered. I think the idea of active story making over passive story receiving has a lot promise, but it's still so far off. I played BG3 yesterday, and just the idea of directing my own little D&D mini-series there, but then can't even control the camera, and wardrobe called in sick again? lol. I wish it was all much further along haha. I think what I'm looking for with D&DRPG is more like a good type-writer that really hums, more toolset than the finished manuscript on the story aspect I guess. Sorry that may have been a dodge, talking around what makes a good or bad story rather than answering the questions, which is very tough. But it was fun to read the impressions, especially for PoE, since I had a similar sort of take on the experience. Memorial day rambles I guess! But good question!
Best Elk
ps. random aside, but just since the AIs are in the news. I was thinking yesterday about something I heard, can't remember where exactly, but essentially about how soon AIs may attempt to replace a lot of work done formerly in visual arts/concept arts with work done in 'writing.' Or kinda writing/scavenging/prompt experimentation I guess. But then, if it's that far along, it's pretty easy to imagine the writers themselves getting AI'd out the game eventually too. I'm sure it'll all come on fast, like it tends to do, but just that idea had me tripping out on the possibility of a D&DAI. Like where maybe it starts with a character portrait, but eventually gets to the place where the DMAI is just writing bespoke stuff for you on the fly. You know, based on your interests and previous plays, combined with your initial inputs. Basically Total Recall style heheh. Like I don't know, but some of the story beats in even the best RPG games are still probably formulaic enough that I bet it could work. Like where part of character creation is guiding the story you'd like to hear told. Or sort of just re-imagining the classic bed-time story approach, where the listener is leading a bit in that way. It makes me wonder if they are doing any real research or putting loot into that sort of stuff. The Wizards I mean