I can easily imagine a set of 'tiers' of challenges, where the bottom tier is super easy stuff for beginners and then each tier up increases the challenge until you're fighting a bunch of hard-level AI's simultaneously or whatever. Or maybe a Mario Bros-style world map that has various different challenges in different directions.
Brood War was famous for 7v1 comp stomps being very popular in custom games, and it was obviously huge competitively, it's the super hardcore competitive RTS, even if it wasn't really planned that way.
The PvE comp stomp crowd seems to really like the co-op mode in Starcraft 2 that was introduced. To the extent that they have complaints, it's mostly that they wish there was even more stuff in it.
I think for the most part, the things that competitive players and casual players want aren't really at odds. They're usually orthogonal desires.
But what does exist, are a lot of people who say "I want to play RTS, but" and will never be satisfied. Like, there's always tons of people saying that they just want an easier to play RTS than Starcraft, and there's been tons of those, and hardly anyone plays them.