I like when people talk about the games getting dumbed down they make it seem like only intellectuals are capable of playing a hardcoe RPG. Lol, I'm pretty sure even preteen kids are able to play most "hardcoe" RPG. I known I did when I was younger.
I've played lots of RPGs over the years, in many different styles. I will say that, at some point, I got tired of having lots of extra micromanagement and/or crap to keep track of. (But, then, lots of micromanagement is one of the things that I avoid the most in computer games. Never really got far in the SimCity games, get tired of RTS's when the number of units gets too large, etc)
I never finished the original Baldur's Gate, for instance. As I recall, it was a partially because of the massive proliferation of quests that built up (I'd go to some village in pursuit of one sidequest, and just talking to people there would add a dozen more. It got overwhelming) and a sudden difficulty spike (I guess I annoyed someone, or got enough reputation, but at some point every map I entered would have a group of nasty dudes firing barrages of magic arrows. Just got slaughtered over, and over, and over.) So.... too high difficulty plus waaaaaaaaaaaaaaaaay too many constantly increasing options. I just gave up.
Not wanting to repeat the endless tediousness of all the "filler" combats in Dragon Age is why I never played that one a second time, too (even though it's plot & character interactions really made me want to).
Edit: the Mass Effect games always strike me as great RPGs. Because of all the dialogue/story/characters/choices. It's not just straight combat like some "RPG"s.