The world of USB-C and Thunderbolt 3 is very complex at first but with the following you'll be all set...
General rules of thumb:
- Thunderbolt 3 cables longer than 0.5m are not reverse compatible with USB 3
- USB-C cables with full 10Gbps (also known as USB 3.1) transfer speeds must be less than a metre long
- USB-C cables with 5Gbps (also known as USB 3.0) transfer speeds must be less than two metres long
What does this mean? That length is really the determining factor for your "ultimate cable", because longer length introduces compromise:
- If you're happy with a 0.5m cable, then the one you've linked really is the 'ultimate', supporting Thunderbolt 3, USB 3.1 (10Gbps), and 100W of charging
- If you want a longer cable (as you say) then you need to make a compromise: do you want a Thunderbolt 3 cable that doesn't support USB 3, or do you want a USB 3 cable that doesn't support Thunderbolt 3?
- If the former, there are lots of good 1 and 2 metre Thunderbolt 3 options from CalDigit, Belkin, OWC, and others.
- If the latter, then you can:
- get Belkin's 1 metre USB-C cable with full USB 3.1 (10Gbps) support from the Apple Store, or
- get something like this Plugable cable which is 2 metres long but only USB 3.0 (5Gbps) compatible.