This useful Windows 11 app finally solved my USB cable confusion
USB Device Tree Viewer showed me why identical USB-C cables behave differently.