> or being so dumbed down and rigid to be actually usable (GNOME, to a lesser extend CDE)

What do you find "dumbed down" and unusable about it?

Press ctrl-alt-T, and a terminal appears. Begin typing.

Press the flag key and a kind of menu thing you can type the name of apps into appears. Type "firefox" or "vscode" as appropriate, begin typing.

It could hardly be made any more straightforward.