I hate RTS games for some inexplicable reason, but I love the cinematics like this. Been a while since I've felt drawn to 40k, nice to feel that again. Just wish Black Library would get it's act together and get quality novels churned out.
They're too busy doing anything to drag out the Horus Heresy and tell pretty much every story about it ASIDE from the actual main events themselves.
As for RTS games, I'm not a fan. I've played Dawn of War 1 and Dawn of War 2. I appreciate that DOW2 did away with most of the base building, but I still hate having to micromanage my troops and activate their abilities. I love the art and animation, though, and the fluff itself is great.
It makes it hard to walk away from these games, but I know that the gameplay itself just will always end up leaving me wishing the game was turn-based and/or a more faithful adaptation of the tabletop game.
For those more in that vein, I recommend:
- Space Marine (just for the single player 3rd person shooter stuff -- MP is deader than a Necron, but was a lot of fun when it was active)
- Armageddon (turn-based epic-scale game)
- the 40K games on offer at GOG.com (Chaos Gate, Final Liberation, Rites of War)