I'll tell you where it started to go downhill for me:

orzammar/warewolf quest was the peak of the game for me.

After that it went downhill for me.

I really liked the different intro stories for Dragon Age. The dwarf ones were just great. The world was incrediblely filled out. Even minor quests like the dwarf chantry felt like they made a difference. The battles were challenging (at least on a PC).

Greatest of this generation is a matter of taste in various areas (art, story, immersion, gameplay, etc). I tend to prefer sci fi so I liked Mass Effect's story more. I like Final Fantasy's art style more as well. I was not a fan of Demon Souls. These are all personal opinions thou.

In the end, Dragon Age is a great rpg that I enjoyed playing. I would not rank Dragon Age as the best this gen but I have friends that definitely do.

lol you mean the fighters guild.

In my opinion Dragon Age held it's top quality from the beginning to the end.

Since everyone is throwing their opinions around I might as well share mine. Bethesda makes the best RPG's this generation. Yes, they sacrifice story in a sense. Their games don't have as strong or as scripted narratives. But they allow you to shape your own story with the absolute freedom they present. They are the only ones taking the genre to where I believe the genre should ultimately end up. Absolute freedom. You can steal from anyone, kill anyone, and go anywhere. NPC's also carry out daily routines and carry conversations with another instead of mostly staying in place, they feel more like living breathing people then in perhaps any other rpg. There are other nice touches like bodies not disapearing like they do in most games. I won't make any arguments for bethesda games having the strongest of narratives but with such freedom it doesn't really matter to me.

That is completely false, Oblivion doesn't allow you to shape anything and it's an awful RPG. Oblivion's world is the most static and sterile world I've seen in an WRPG in a looong time. And the writing is one of the worst I've ever seen in my life.

Not exactly.

There's a mod that restores most - not quite all - of tthe cut content from the game. Lost dialogue options, characters coming into play at different parts, whole scenes and scenarios restored. It's quite great.

Oblivion is a tricky one for me, a lot of people seem to praise this game, but i did not really enjoy the story or characters that much, the world felt kinda empty.

Fallout 3 is so much better in my opinion.

But still i wouldnt take Betsheda's RPG's over Bioware and Black Isle.

was the mod put out by obsidian? Because if it wasn't than it has nothing to do with obsidians ability to create games.  In fact, it kind of sends the message that Obsidian needs somebody to come in and tidy up the mess of a game they made.  

No it wasn't made by Obsidian, but it was using assets that already existed within the game code. It's well-documented (Avellone has said this repeatedly) that they, Obsidian, did not have time to implement all of the content they had made for the game.

I agree. Oblivion's world feels like it was built in a freaking map editor. Absolutely static and unchanging. Nothing to discover to reward your explanation. Generic townspeople with way too many repeated models, no enemy variety, the worst level balancing system ever, a mediocre combat system... truly a horrible game. There was nothing redeeming about it except the sheer size of the world, which is completely nullified by the fact that there was nothing in it.