My guess is that the cable holding the counterweight would break long before thatIndeed, a longer radius is preferred in this case.
I wonder, at what point a hypothetic space elevator can "naturally" provide a gravity force, since the thing will track Earth's rotation anyway, and the counter-weight terminal would be situated past the geostationary orbit?