"The fixed point has to be the satellite end (where there's a stonking big bit of rock or something as a counterweight), not the Earth end"

Actually, the CENTER point ( in geosynchronous orbit) is the anchor- the ends are NOT support points.