Modelling a twist like this procedurally
As you suggested, you can use Simple Deform modifier for this

One modifier set to Twist for the spiral
Angle around 1080° for three twists, and use limits to move it up/down
Second modifier set to Taper, and adjust to your needs.