I've enjoyed the Obsidian RPGs I've played, but the major problem I have with them—especially apparent in KotOR II and New Vegas—is that they really aren't good with grey-and-grey morality, despite how they try to make it a major part of those games.
With KotOR II, they changed what was a very good Star Wars story from the first game into "Revan didn't just fall to the Dark Side, the Jedi are just too stupid to realize that!" with things that didn't exist at all in the first game's plot. You could probably make a good deconstruction of the Jedi and Sith, but having a Star Wars game that acts like it's better than Star Wars by just trying to make the Jedi look like idiots for the sake of "deconstructing" them doesn't really work. The main problem, of course, is that the game adheres to the prior game's Light Side/Dark Side morality mechanics—and taking the choices that agree with Kreia's "deconstruction" attempts almost always gets you Dark Side points. Let alone that (spoiler) Kreia is so blatantly and completely evil and her goals are made clear to amount to mass murder.
With New Vegas, they give you three different factions to choose from, as well as the "your own rules" choice. Said three factions are a capitalist who really doesn't care about anyone outside of his garden of Eden, a bunch of psychotic murderous sexist savages, and the faction that—while quite overburdened and lacking in resources—is the only faction that actually provides aid to the people at large and protects them from threats. Essentially, the argument for the NCR having a few "bad apples" doesn't quite weigh them down in comparison to a faction that has no good apples at all. Even your companions are heavily weighed against the Legion, and the one time one of them actually speaks somewhat positively of the Legion is a massive out-of-character moment given that companion's backstory. And to add to that (spoilers again) the NCR ending is the only ending that can get positive outcomes for every good faction in the game, as well as the only ending that gets positive outcomes for certain groups such as the Brotherhood of Steel.
(Though in fairness, there is something to be said for "trying to help people actually helps them" in games, so they're better than CDPR in that regard. )
I can see where you're coming from with Revan and the Jedi. Personally, I do find everyone's favourite glowy sword-wielding monks pretty dense, but then both sides are pretty daft when unifying their ideologies would solve a lot of problems for everyone. Then again, that's probably the point.
I quite liked the new interpretation of Revan, though. Less of a good guy gone bad and more someone who fought for his cause no matter what, donning and shedding identities as needed. The part I took exception to was the concept of 'true' sith. I still can't put my finger on why, exactly, but I hate the thought. That was one of two reasons why I refused to play the MMO until my friend got me in a virtual headlock and made me play it to realise I do, in fact, enjoy it. The other being how they dealt with the Exile, but that's a whole other subject.
I'm thinking it really depends on one's playstyles or what aspects that one enjoys in a game, and personal tastes (like anything else in life).
I'm not one for RPG elements (maybe some JRPGs) so I'm not a hardcore RPG gamer.
I just love the freedom and exploration, and the beautiful worlds.
I just like to have fun in a casual sense, especially with more action-oriented stuff.
I'm more into Action-Adventure/Action games like Tomb Raider (the original 90s ones which I grew up on), so the more action-y RPGs tend to get more of my interest.
While I do enjoy some story stuff and some minor RPG elements, I tend to enjoy games more for action/arcade, simulation (like Harvest Moon or Sims), or exploration and freedom than tons of story cutscenes and/or RPG-strategy elements.
I'm terrible with strategy and impatient with stats-stuff, so I tend to not enjoy most "pure" RPGs (or JRPGs or strategy games) all that much, and I tend to drop them at a faster rate compared to other genres.
Anyway, I just love customization and freedom to explore worlds, which means the Elder Scrolls games are more fun for me to play than most pure (or old-school)RPGs.
I'm a "casual" gamer who loves to hack and slash, so I think this is why the later Elder Scrolls appealed to me more as the games got somewhat more "action-based" than strictly stats-based (Oblivion and Skyrim over Morrowind).
So, for me, Skyrim satisified me enough to buy three different versions of it...
Likewise. I've played both actiony and more traditional RPGs as I grew up and can appreciate both, but I don't miss farting about with largely arbitrary numbers to determine how well I can swing a sword.