One of the main problems with Oblivion is that it doesn't have the same world depth that Morrowind had. Sure, it has dungeons littered about the landscape, and there's no shortage of adventuring, but there are not nearly as many factions. Morrowind had the 3 Houses, the Fighters/Mages/Thieves guild, the Morag Tong, the Imperial Cult/Legion, and I'm sure I'm missing some, all in addition to the main quest. Even then, some were mutually exclusive, making you really feel like you were in the world. If you got to the top of the Fighter's Guild, people reacted to you differently. They recognized you.
In Oblivion, you still have your 3 guilds, and you have the Dark Brotherhood. That's it. There are no other factions to join, and each one has somewhere on the order of 10-15 quests, including the little mini-quests at the beginning just to whet your appetite. It seems short. Not only that, but you can have one character complete all the factions. There are no stat requirements for advancement, just quest requirements. You can complete the Mage's Guild with little or no actual experience in magic, and they still call you the archmage. It destroys the immersiveness. Even so, many of the quests are very well-constructed and you feel accomplished for having completed them.
The combat system is vastly improved, and it is satisfying that any attack you make will hit and deal damage so long as the animation hits. One of the most annoying parts about Marksman in Morrowind was that even if you managed to hit with the arrow, it still had a chance to miss based on your Marksman skill.
Another major gripe is that most of Cyrodiil (the world for Oblivion) looks relatively the same. The area near Skingrad has a lot of colorful flowers and the area near Leyawiin looks vaguely like a marsh, but for the most part everything's green. The regions are not as diverse as they were in Morrowind, and you shouldn't expect to find any interesting fauna like mushroom trees about the landscape.
One of the main difficulties is the fact that the enemies scale to your level. If you don't plan your skills carefully and account for what enemies you'll be facing, you will quickly find yourself outmatched just during the normal gameplay progression. You need to have multiple sources of damage, or else you will come across battles that are either unwinnable or take an excess of time to win. For example, one swordsman I made could never kill skeletons, no matter how long I bashed away at them. All my swords would run out of durability before the skeleton died, so whenever I encountered them I either had to run or hide. This can be fun or not, depending on your play style.
Oblivion is a fun game, but it's not the same game. If you go in expecting to have Morrowind with enhanced gameplay, you'll be disappointed. If you go in just looking for a fun time, it is certainly a worthy title. It's worth playing through once or twice, and the Shivering Isles expansion packs is one of the most fun times I've ever had with gaming.
Best Answer
This is a quick answer BUT in the Dragonsreach there is a book in the same room as the enchanting table that explains all events of Oblivion and briefly summarizes what happened in-between the games. Including that the Septim dynasty ended at the end of the main quest for oblivion and names the new dynasty that controls the empire.
Add On:
The third era ended and the fourth era begins when you and Martin Septim defeat/banish Mehrunes Dagon. Hit this site its a pretty good timeline for the 200 missing years including Hammerfells exit from the empire and Vvardenfell being destroyed.
http://www.uesp.net/wiki/Lore:Fourth_Era