the spline deviation (the straighter bit at the beginning I’m guessing you mean) can’t be removed with it still a parametric object, you have to make it editable and adjust the first points bezier a bit.
The Tracer is easier for making a straight connection between two objects and doing it between nulls makes the offset to the bottom of the cube easier (one null as a child of the cube and one a child of the sphere – though it does really need the null as the child of the sphere, the sphere could be used by itself).
Rotation of the sphere, depends on the connection, if the line is solidly attached at both ends (no swivel joint) it shouldn’t rotate at all.
Helix should be more of a bowl for realism as the length of the connector should be constant.
9487_pendulumtrial.c4d.zip