I think you have to give Bethesda create for embracing the modding community and creating the foundation to build upon. Personally, I've always enjoyed Bethesda games. Daggerfall, Morrowind, Oblivion, etc. I've had good times with all of them. I don't wait eagerly for their releases though, because I don't even bother to play them until a year or two after release. Give it time for all the DLCs and mods to come together, then it is quite a good experience.
Also, Bethesda did not create the MMO, it was another company. I do believe Bethesda published it (could be wrong here), but they did not create it. I have not played it, as after Everquest, I vowed never to play another MMO. The time commitment was too great.
@Shyao: You're better off just waiting and seeing. I will say that there is more to a day than running a single errand. Typically, major quest lines or rival quest lines advance to the night system. There are a number of side quests and minor events though to find as well. The day/night system is not timer based, so you could run around for hours if you'd like without night ever coming.
The 9 days is a bit misleading, because of all the choices. It could take more days for some playthroughs and fewer (although not much fewer). I can tell you, I believe you should get 8-10 hours out of the release to find everything. If you read super fast, probably less, but I'd expect at least 5 hours at a minimum. For someone like me who checks EVERYTHING and searches everywhere, it'd easily take 10+ hours.