I hear ya. You are far from the only one with this issue.
(Personally coming out with a new cable and not acknowledging the decades old industry standard of USBA isn’t the most consumer friendly thing to do). It doesn’t just affect folks like you with older devices but also Windows users.
All I can suggest it to keep looking and find someone that has personal knowledge of what ones work. I’m afraid I don‘t have either a pro or mac so can’t experiment.
You can send them feedback and let them know the issue. Perhaps that will motivate them to come up with a solution
Product Feedback - Apple (beyond thinking that you just need to buy a new mac with USBC connections)
If I find someone with a good solid solution I’ll post it.