Can I trip over that cable? Sure.
Have I ever tripped over it? Can't say I have.
I don't make the design decisions at Apple. But I look at what Apple has offered and I feel it has plenty to offer. Just see what you have gained from giving up MagSafe. In exchange for losing one dedicated charging port, I now get a more general purpose port which can be used as a normal USB port when I am not using it for charging.
There is now no such thing as a wrong port, because now each port in the MacBook is either an USB C port or whatever port you want it to be with the right cable and / or adaptor.
From a design perspective, it does indeed seem so much more elegant to me.