That trailer was sort of awful.

And Oblivion was a great but overly long demo illustrating all of the capabilities of the game engine used. Too bad it was never fleshed out into a full game.

But at least Fallout 3 was a well-done complete game made with the same engine.