I mostly just bought it because I love how insane their last game was (EYE) and it shines through a bit in Deathwing though the production values are much higher so the nonsense is constrained.
I'm having a hard time getting into it though, it's just too slow for my taste. I would've liked it better if you were able to play as something a bit faster and more agile than a giant walking tank that literally clanks up and down corridors
If you like RTS and can deal with the dated graphics the original Dawn of War series was awesome. DoW2 is alright, more squad tactics than RTS though and DoW 3 is a bad MOBA. Space Marine is badass if you want something more action-oriented (forget multiplayer though). I'm considering the Battlefleet games while they're on sale
I'm pretty sure I have at least 1 other 40K game in my library and it's an RTS, I'm not sure which one but I never got around to playing it. I'll check. I think it's a Dawn of War game.