People in 2026 have never seen duct tape unless they work in hvac. Duck tape, on the other hand, is in every household. On which topic, i think you're missing the point: duck tape is never the best solution, but it's good enough in a pinch for an incredible range of applications, and it has long shelf life. Think of it as a hacker tool.
The truth is nowadays you can just choose your favorite brand and they almost certainly have a correct, and good, adhesive selector.
For example, for loctite, you should just use: https://www.henkel-adhesives-selector.com/