There aren’t any DEs that for example mimic macOS (modern or classic) and the few that do something different (e.g. GNUSTEP, CDE, etc) don’t ship with distros. As far as I know there haven’t been any recent DEs that were designed from scratch based on research from new user trials and usability studies (which is unfortunate; most of data in this realm dates back 20 years or more and could probably benefit from addition of new data from a modern context).
I cannot tell how well the distros that do mimic MacOS do it, but from what you say it is not well enough (at least not Pantheon).
If we're talking the files+folders paradigm, then there's not much innovation remaining outside of cosmetic changes. Desktop computers are "done" much the same way automobile interfaces (steering wheel, foot peddles, etc) are "done". I think true Desktop innovations would require a paradigm shift or new hardware, like eye-tracking or a BCI.
I agree about the lack of standard key bindings is a problem. It is definitely a problem with things like text editors. Even worse between modal editors, or a mix of modal and modeless - I generally use Helix and occasionally using vi (or nano, or anything else) is a pain.