I kind of solved this by moving the actor with the rope component to the starting location of where the new rope will be attached to and also setting the rotation of the rope to match the orientation towards the end point. All of this at the construction level.
This fixed the crazy movement by some 90%, I still have some minor movement left over but still very helpful.