That Fedora one is very biased, written by the advocates for UsrMove. A better way would be to search on Google for:

      site:bugzilla.redhat.com "UsrMove"

which produces page after page of bug reports.

The reality is it caused lots of breakage throughout the system which required many man-hours to fix over years.

The gain from it is pretty minimal. And there are still bugs everywhere, for example these two commands ought to the do the same thing, but in fact the first breaks and the second works:

    # dnf install /sbin/ifconfig
    # dnf install /usr/sbin/ifconfig

(It's something to do with either RPM or DNF not "knowing" that the two paths point to the same file, even though /sbin is a symlink to /usr/sbin. Various attempts have been made to fix this but obviously we're not there yet).

The good thing from Debian's point of view is that Fedora and Arch already fixed many of the bugs, so things will probably be smoother for Debian.