What about these small spindle wheels with crank drive, though? They did get a mention already. Usually, the really small ones are winding wheels to wind bobbins or pirns for weaving, and are not really suitable for spinning. That does not mean they cannot be used for spinning at all - they can, and I know of a few people who have used them for just that, and there are even a few old illustrations showing them used as spinning wheels - though these might not be the really small ones, but medium-sized wheels.
[caption id="attachment_3350" align="alignnone" width="1775"]
Detail from: Tobit en Anna met het geitje, Symon Novelanus, 1560 - 1590; etching, h 213mm × w 180mm. Rijksmuseum NL,
see the original file here.
In my opinion, centre-crank-driven wheels are not really suited for production spinning due to the stop-and-start procedure already mentioned in depth. On old illustrations, these smaller spindle-equipped wheels are often found in the context of weaving workshops - there might also be some spinning shown in these pictures, but the presence of looms makes it pretty clear to me that we have winding wheels in action here.
Small wheels, centre-crank-driven and equipped with a flyer, however, are a different beast altogether, and they were definitely used for spinning, as lots and lots of pictures show.
[caption id="attachment_3351" align="alignnone" width="862"]
Detail of Arbeidzaamheid, Crispijn van de Passe (I), 1589 - 1611, engraving, h 211mm × w 144mm. Rijksmuseum NL,
see the original file here.
The game-changer here is the flyer, though, as it eliminates the need to stop and start the drive wheel by conveniently twisting and winding the spun yarn at the same time. So once you've brought your wheel up to convenient speed, you can happily crank on to keep that speed and spin with your free hand.
[caption id="attachment_3349" align="alignnone" width="925"]
Old Woman Spinning, Nicolaes Maes, 1650 - 1660; oil on canvas, h 63cm × w 55cm × d 9cm.
Rijksmuseum NL,
see the original file here.
So - centre-crank driven wheel with spindle - winding wheel, centre-crank driven wheel with flyer - spinning wheel; though this is not a Great Wheel, then, obviously.
Also obviously, turning the crank requires one hand, leaving only one hand free for drafting. This means these wheels are always shown with an attached or accompanying distaff to hold the fibre and provide some resistance for drafting. Since the speed that you can build up turning the crank on the small wheel and the ratio between the wheel and the flyer pulley is not going to be very high, these wheels will not give you a yarn with particularly high twist, and the bobbins do not look large enough to accommodate sensible quantities of really thick yarn, which would be nicely stable with relatively little twist. So my personal opinion is that these spinning tools were predominantly used for flax/hemp/nettle, long fibres that do not need a large amount of twist and that can be drafted quite easily with one hand only.