So that's where real hardcore gaming left. That's the series that hasn't succumbed to casuals and market. Nancy Drew.
I acknowledge the jest in what you say and also the truth. That Nancy Drew has maintained concurrence for 19 years and produced 31 games in that time and still has more to come flies in the face of so many excuses we hear day after day on the codex as to why our beloved studios can't make decent games and why its so hard for indies to do the same. Vogel's Spiderweb studios is proof that such a thing would have been viable for an RPG developer over the same time period.
I wont rehash all the excuses we've all heard, from the money men to the development teams to the fanboys, but the critical moment IMO was Bioware's sudden redirection towards the console market. In 2003 they were having perfectly acceptable success with both Neverwinter Nights and Knights of the Old Republic, but suddenly, as if someone in the company had a dream, everything just went dead. Nothing was heard from them for the entirety of 2004, after a ceaseless 6 years of providing more than one new product a year. Were they planning something huge? Nope, in 2005 the big wait ended with the release of... Jade Empire, some console aRPG. Not because the PC games weren't making money, but because they thought they could make
more money making console games. You know, for dick measuring competitions at conventions.
But what was happening in the real world while the greed infection stalked Bioware towers? People were making Neverwinter Nights mods. Thousands of them. Some of them were even quite good. And people were still making them and circulating them throughout the 10 years after Bioware ceased making NWN content. The NWN OC might have been a can of ballsacks, but the expansions are quite widely loved, as are many of the better fan-made mods and there's no evidence at all to suggest that Bioware couldn't have continued making NWN games for the duration of the 2000s, be the Nancy Drews of RPGs.
There is, of course, the issue of the problem of D&D licencing, but most things in life can be worked around if the determination and time is there, and let us not forget, the whole of 2004-2006 brought nothing of value until they finally cracked the console market with Mass Effect. Even if you argue "I'd rather have Mass Effect than 10 years of NWN", which might be a valid claim for your tastes, then you're still not benefiting from investing in following Bioware because 3 years later and $860m is something no human with a primary desire for money can refuse when EA comes knocking (your beloved gameplay down).
The very same issue we have today is the same issue we had back in 2005, why, exactly, is no-one willing to test-out making 'normal' profits from a stable cRPG franchise? Why has it been left to independents to fill this void?