The cool intro video is not included with Rise of Godslayer Discs, Steam version or download version of game. I have gone to great lengths to verify this. It is only on original discs, and even then the latest patcher deletes it for some reason.
My only guess is that Funcom no longer owns the rights to the video? Maybe it was owned by Eidos, or Gaute Godager's sister or some other entity of the long mismanaged Funcom corp, who knows, but its gone.
However, if you can get a hold of the original game DVD's install the game, but do not launch. Go into the media folder of the installation and find the videos. Copy them somewhere. Then go ahead and run the patcher and fully update it. Then when complete put the videos back and the intro video will run again.
Its worth doing, the intro video is quite awesome. And if you can find the original DVD's usually for about $6 they come with 30 days premium game time, so that saves you $7 right there.