Starcraft and Starcraft II, and Warcraft I,II,III had great campaigns. So it is kind of ironic that a lot of the games copying them cut the campaigns for the esports focus.
Tempest Rising is a newer RTS (this year) that's also in the C&C style, its highlight is the campaign. (Multiplayer I think is basically in the go-to-discord phase already.) The real problem is that RTS is just an unpopular genre, whether it's taking design inspiration from the C&C branch or the SC branch.
It was particularly visible in how, if you edited the map so that every pile of resources was 50k, so essentially endless, you'd arrive at a stalemate.
Given (effectively) unlimited resources within base distance, Zerg undoubtedly have a fairly substantial advantage and will probably win. Assuming comparable player skills, of course.
Their remax time is 1/3-1/4 that of Protoss/Terran, they can tech-switch near instantaneously, and they have some of the most powerful endgame meta. This was true for SC1 and Brood War, and it's even more true for current SC2.