That is really a subjective question, and depends on the condition of the trackball in question, and your playing style.
In general, no they didn't require alot of spinning--if you could move the trackball quickly.
If you get on a machine with a poorly maintained trackball, then it will require more spinning to get the cursor where you want it.
On Missle Command in particular, you could "spin" the trackball, and have it continue after your hand left the ball--getting you to the other side.
I set both so that a quick spin in a given direction, with very little "hands off" time, will get you all the way from corner to corner.
That way I don't "run out of hand" on them.