I've been playing that one for 12 months, pretty sick of it now tbh.
For traditional RTS there's Planetary Annihilation: TITANS and Company of Heroes 2. They're both well regarded but I can't vouch for them personally because I fucking hate traditional RTS.
There's also the ANNO games if you're in the mood for something excessively German.
For something with a more HOMMy/4xy lean there's Age of Wonders III which is pretty cool. I need to play more of that.
If you're open to something a bit weird then I'd *strongly* recommend Creeper World III or its (kinda) sequel Particle Fleet: Emergence. The former is amazing and the latter is probably even better but I've not played enough to be sure yet. They're essentially RTSes where the enemy is a fluid.
Kinda stretching it for RTS, more of a management game (but in the same vein as Prison Architect), Rimworld is *very* good. It's great at generating interesting emergent situations.
Also Europa Universalis IV and Crusader Kings II (and Stellaris but it needs to be fleshed out) are *technically* RTSes so I'll mention them cos they're great.
Going to try Planetary, then look at the other non-traditionals you mentioned. Not really sure what I'm after - something between a management/economic and rts I think.
Rimworld would fit that bill. But it's fairly slow paced. Maybe XCOM? Not what you're asking for exactly but might scratch that same itch. XCOM2 (which is better) is in the current Humble Monthly for $12.
So Planetary... I can see why people like it, but I can also see exactly how it's going to go. I'm bored just thinking about playing it.
Rimworld next.
Well that went well. Everybody's dead.