I've been discussing this with older RTS gamers for years, now. I did a lot of experimentation in SC2's editor. Where I arrived at is that RTS games evolved into MOBA games after DotA. That was how automated unit production was finally solved and balanced with RTS gameplay, the player focuses on one part of the battlefield while the production operations continue behind the scenes, with static defenses in place at the start of the match.
If you want to evolve RTS games the place to start is not adding automated unit production to Warcraft 3, that's been solved. You want to try to take DotA and convert it back into a base-building and defending game. I have a very good idea how this can be done but I was told not to build it and release it on any existing RTS as a mod unless I want it copyrighted by that company, since the loss of DotA IP rights was a cautionary tale for the industry the Terms and Conditions are such (especially with SC2) that whatever you make is Blizzard's property.
On older RTS gamers, they believe that resource collection and onerous repitition is essential to the enjoyment of RTS games, much like the way people who drove cars with manual shifters and compression brakes were dubious of automatics and vacuum-powered ABS systems. So you're never gonna convince with words what is possible. But DotA is too simplistic and casual for most trad RTS fans. Something has to be done to bring the genre back.
Edit: At this point setting workers to gather stuff and continually building to maximize production, while trying to scout and then build a counter, and push with good timing is tired gameplay. The gameplay has become somewhat of a meme. For one thing, people have found ways around it and invented ways of cheesing the system too many times in too many ways, playing the game properly is mostly just an act of courtesy and etiquette. Many times games can be won just by spamming the right unit. It's just a numbers game. HP vs DPS and unit flexibility/mobility and RANGE. Boring unless you love endless repitition for marginal improvements over many months.
Of course it's a matter of taste, some people still play old games and still love them.
I like innovation, I think most people do. So its not about old RTS games being bad it's just not fresh anymore.