I have a 5mm pitch ballscrew on my Z axis. No problems when powerd off, the stepper has some resistance which is enough to keep it from moving, at least in my case. The weight of my Z axis is a bit over 10kg.
I think it might be a problem if the pitch was 10mm for example..