Tarm: I don't like clickfest rush RTS games. The W40K setting made me tolerate Dawn of War but not much more. Dawn of war 2 on the other hand I find quite fun. I'm not very good at it but I like to play it anyway. :)
Oh and Last Stand is ridiculously fun with friends. :D
I love the W40K setting so much that I can get into almost any game with it to various degrees. I tire quicker of them is about all so some I play more seldom and not that long.
Favourites are:
Final Liberation: Warhammer Epic 40,000
Warhammer 40,000: Chaos Gate
Dawn of War 2 (Mainly the version with the most armies for variation.)
Might be others I forgot.
Yeah the tabletop is a whole other beast than the computer games.
Yeah, if you don't rush/harass early in a DoW game, then you're gonna have a bad time against even a half-decent player. A defensive playstyle doesn't really work at all in DoW.
My only complaint about DoW2 : not enough space hulk type missions! There's only like 2 or 3 such levels among all the games, and I found them the most fun of all :P Oh yes, and no single player Last Stand mode, which indeed looked like a ton of fun!
Chaos Gate looks phenomenal, but it has always bothered me that you only ever seem to fight against Chaos Space Marines. Especially given its XCom influence, where the aliens come in great variety, it's a pity that you don't get to square off against Eldar/Tyranids/Necrons and most of all, Orcs >:D