I've seen some fairly big height gains (10m plus) on machines used for irrigation in Turkey. The key limitation is the requirement that the cylinder be set at 45 degrees or thereabouts, so horizontal space (as well as the vertical) is needed. In theory, the length is unlimited - assuming there is sufficient power to lift the weight of the water. You don't have to go for an internal helix either - the same result can be obtained by spiralling plastic tubing (such as large bore hosepipe) around a solid central shaft but it is harder to mount.