I think the problem is simply that for a large part of the playerbase, increasing your APM is directly correlated with increasing your win rate/ranking.
And frankly, that's not fun for a lot of people.
I don't want to win by clicking and mashing hotkeys like a schizophrenic on speed.
I don't think this is true. Granted, last time I tried to get good at an RTS was toward the end of the Brood War era but the established wisdom at that time was very clear that hour-for-hour, time spent practicing resource management was much more effective than time spent practicing clicking quickly.
Yes, really good players click fast, but they also have impeccable resource management. The group I played with did run the obvious experiment: the best one of us was forced to play against the rest (one at a time) with an artificial click frequency limit. He felt like his abilities were greatly reduced, but he still beat everyone else quite easily.
Yeah, I played a lot of StarCraft 2. By myself, 2v2 with a really talented friend and 3v3 with two other friends that were total beginners that I could beat 1v2.
At the bottom to upper mid level all you need to win is to figure out the macro game of building construction while also getting enough workers and units. With enough of that no micro is needed, just attack-moving into the enemy is more than enough.
Then at the upper mid level you're going to run into people who often don't build as effectively but they'll micro every unit or they'll be constantly doing raids when you don't expect it, scouting better than you and/or just understanding which units are better vs which so as to counter you.
From that point on it becomes much more of an effort to play the game because then you need to become better in all of those fields, while also becoming faster. But to be honest that point is probably 2/3rd's up the tree of all the people playing.
When people complain about APM in an RTS like StarCraft, they’re really not complaining about the spam clicking done by players at the pro level. They’re talking about multitasking which is an essential skill at all levels of the game.
Not even at the lowest rankings are you permitted to ignore what your opponent is doing and focus on building workers and base facilities. StarCraft is infamous for the ability of anyone to sacrifice their economy to perform an early rush attack (most infamously with a ton of early zerglings).
To combat early rush attacks you need to be able to multitask: send out early scouts to see what your opponent is doing, if they have any hidden building on the map, how many workers they have, etc. You need to be able to do this while building your own workers, base facilities, and units for defence. This is the multitasking that so many struggle with and it’s required to be able to play at the most basic level!
Optimally queueing SCVs and marines and supply depots requires an APM of 11 or so in the early stages of a Brood War game on the fastest setting. Add a couple more APM for scouting, and we'ree still not talking crazy levels of multitasking.
Dealing with your opponent is a fact of every strategy game!
And yet if you watch low level players they’ll be fine with that until a bunch of zerglings show up at their base and then they panic trying to micro marines and repair bunkers while their minerals shoot up to 1000 and then they have no units and lose.
Keeping a scouting SCV alive in your opponent’s base while building more SCVs at home, building more barracks, building supply depots, killing the enemy scouting worker, and actually reading and correctly interpreting what your opponent is doing is non-trivial.
And frankly, that's not fun for a lot of people.
I don't want to win by clicking and mashing hotkeys like a schizophrenic on speed.