Tensile strengths of metals and metal alloys,
Steel has a tensile strength of between 400 and 2000MPa, depending on the composition, bronze has ~450MPa and gold ~120MPa for comparison, based on the weight of most metals, the only ropes that would feasibly work without snapping would be: steels and steel alloys, titanium alloys, cobalt nickel alloys, possibly aluminium?
Thinking about it, aluminum probably wouldn’t be good in the Nether either, much lower melting point, even before reaching it its tensile strength would reduce dramatically.