FFXI managed this perfectly, and as a CONTROLLER BASED GAME...

Mage jobs had literally dozens ... upon dozens... of abilities that jammed up every key on the keyboard and then some,
and all of them had a real purpose.

If you didn't like that, you could choose Monk for example, instead, and have just a few abilities in simpler rotation.

Or choose a job that sat somewhere in between, like Dancer.

IMO the two biggest killers to this games ability to be truly great are its vertical design
And the holy trinity.
Neither will ever be fixed.