>>2124591 (OP)
It was a puzzle game masquerading as an RTS.
Speaking from a strictly chad-singleplayer perspective, since multiplayer people are sexual deviants:
All you did in DoW 2 and the DLCs was to go from one corridor to the next, only stopping to solve set pieces. Advance forward, stop for cover, kill the scripted enemies attacking you with either the right weapons or convenient armament lying about, rinse repeat.
The story was serviceable, Retribution in particular had some good story beats and interesting characters. But it was still a puzzle game.
There was some minor RTS stuff in skirmishes (and MP) but not enough to satisfy any actual RTS player, as evident by the popularity of the Last Stand mode, something only RPG players enjoyed.
>What went wrong?
The game should have been marketed as an RPG and under a new title, not Dawn of War.