But you also complain that games devolves into a speed clicking competition? You see the contradiction there right?
From a game design perspective the whole point of resources is that they limit the number of simultaneous actions any agent can execute, whether that agent be a unit, a human player, or an AI.
I'd wager the reason the computer is steamrolling you every time with its superior APM is that for a full 40-50 minutes at the start of every game you are doing absolutely nothing to prevent its intake of resources. Then its shocked_pikachu_face.jpg that the AI with its fully built out industrial war economy, calibrated to give it some hope of holding its own in war of attrition against actual ladder players, smashes your scenario-editor model army and sim-city town in 30 seconds.
I actually do sympathize, because I mostly play the same way too. It's more fun. But the game is designed first and foremost to be fair and competitive in PvP, and that is a much harder challenge than making a fun PvE sandbox. I agree that 0AD doesn't have its balance right yet, but most of these guys have been working on that problem for years with little progress. All the easy solutions have been tried and found wanting.
I honestly think many of the games that get it right, like AoE2 and Starcraft, are actually products of incredible luck, not skill! They happened to stumble onto an improbable pseudo-balance that resonated with a certain audience, which then built a community around forgiving or mitigating the lingering issues. 0AD has not hit that tipping point yet and it may never do so. Most RTSs don't.