Dark Brotherhood is only decent Oblivion questline, imo.
Problem with guild questlines in Oblivion and Skyrim is that they're completely separated from the world and overall storyline (happening in a vacuum), unlike Morrowind.
Beefcake was like Canderous Ordo's dumb little brother. Until he unmasked himself as Carth's dumb little brother when he didn't want to bang Femshep. What an idiot.
That quest where you had to accompany the supposed master thief Mercer was embarassing. He tripped every trap in the dungeon and alarmed every single Draugr. At least with the other two there weren't such issues.
But the quest where you needed to steal from the Dwemer scholar was quite good; using traps against guards, etc.
The PSP in-game movies are very bad compared to the original. I hate the Final fantasy touch Squeenix added. It looks terrible (at least they left the music alone).
Original had classy 90s anime style.
http://www.youtube.com/watch?v=j-JJXbF7cXc
I actually had my eye on the Amazing Spider-Man game that deals with the aftermath of the movie, but forgot about it. Must've dropped in price on Steam already.