Hi Bill,
I'm not sure if you mean freewheel as in overtravel after you shut off, or backdrive. It's true that the stepper motor will just stop and hold. A gearmotor, especially one with a high reduction ration (like the ones given as examples), will generally stop very quickly. You can stop it even quicker if you wire your motor switch such that the (+) and (-) leads are shorted when you turn it off.
Whether a motor will or will not backdrive is another matter. Generally speaking, a worm drive gearbox will not backdrive, but you can under certain circumstances - usually causing undue wear to the worm gear (the gear that's normally driven by the worm).
A non-worm gear box can be backdriven, but you have to satisfy some requirements first. All motors (even so-called cogless motors) have some detent torque. In addition, there is static friction (AKA stiction) and kinetic friction (AKA running friction) to consider. Assuming the gearhead is 100% efficient (which they never are), the torque required to backdrive a gearmotor is the gear ratio times the sum of the restraining torques (stiction + detent for a stopped motor). There are a few more contributors, but those described above are the major players.
All that theory being what it is, I've been presuming all along that you're simply planning to drive your existing leadscrew with a stepper or gearmotor. If this is the case, no worries. It's difficult to backdrive a leadscrew alone. Adding the gearmotor to it, menas you have to overcome the backdrive torque of the leadscrew PLUS the backdrive torque of the gearmotor. If you have a ballscrew, the situation is a bit different, but you still have to overcome the backdrive torque of the gearmotor.
All in all, I strongly believe things will all work out fine with a gearmotor -especially if you use one with a large reduction ratio.
If you end up using a stepper, you have one more thing to consider. Steppers have significant unpowered detent torque which you'd need to overcome when using the cross slide manually. The best bet, in both the gearmotor and stepper case, would be to have some method of disengaging the motor from the leadscrew for manual operation. Say a mechanical or solenoid operated tooth clutch or particle clutch or one of your own design.
John