RTS campaigns are never good and they never really have been. Most of the time it's either a boring slog with the enemy given some sort of random artificial advantage or it's an annoying mission that has you controlling a handful of units in a way that generally breaks most of the features that make you want to play an RTS game in the first place.
I truly don't understand the people for whom the campaign is genuinely enjoyable.
Say it's Starcraft 2 or World in Conflict. Great stories, interesting gameplay and cutscenes.
For me, the single player part is equivalent to the multiplayer in importance. I can't remember how many times I've replayed CoH1, SK2 or WiC it's like rewatching one of my favorite movies.
When I saw that the CoH3 campaign would be a dynamic map, even then I realized that it would be a complete failure. Beta clearly showed this - it's a boring set of skirmish.
It’s just that Relic apparently doesn’t have a competent script writer. CoH1 was great, and it was so because it was based on great movies like: Band of Brothers, Saving Private Ryan, A Bridge Too Far. Right now Relic is not competent and the best move for them was to make a remake of CoH1 (the US they already copied their first part). On a new engine and adding more events to the campaign. They fucking took Italy and didn't make Italy, neither as a playable faction nor as a campaign.