What is the best way to animate tension?
You could use a bezier curve, make a middle vertex, hook the vertex to something using ctrl+h (empty works best), use a medium noise on z location of the empty and a low noise on x or y so it moves left to right, and as the rope gets tighter reduce the strength of the z and decrease the scale so its movements are faster and tighter
If you want more detail just ask.