Notice that the force to "break free" the root is 7.46 N and the force after that is less, but you can slowly measure those lower forces because the displacement has a linear ramp over time.

If you apply a Force to the root instead of a Displacement in Static Structural, not much happens up to 7.46 N then there is no equiliburium after that point because the root broke free and is unconstrained, that is why you can only solve it in Transient Structural.

If you solve the model once, you know when a displacement threshold was crossed, so you can manually set the end time for a second solve to the value you looked up on the first solve.  Sorry, I don't know how to do it programatically.