I find this especially true with USB-C to USB-C cables pre-USB4/TB4. Is it
• only USB 2, especially with some older USB-C to USB-A cables, and only for 5V 500mA charing
• only USB 3.2 gen 1 with 5Gbps and charging only at 5V 900mA
• only USB 3.2 gen 2 10Gbps 5V 1.5A
• compatible with USB 3.2 gen 2x2 for up to 20Gbps and 5V 3A
sad times when all of these look the same and are generally not marked at all. That's why I suggested a USB4/TB4 cable if you wanted to stick with a USB-C to USB-C cable, as these are usually marked with TB4 or 40Gbps and are fully backwards compatible with all the mess above. You would also be able to use it if and when you might get a new Mac and/or external drive with USB4/TB4 without having to start the whole cable process again
Your current best bet still is a USB-C to USB-A cable with USB 3.2 gen 2 specs, as linked to above on Amazon, as not to have too use an adapter as well.