How do you make the perfect S curve?
The mesh and the curve need to start in the same place for best results.
Your mesh is probably a bit offset.


Set both origins to the same place
Make sure both curve and mesh start at their origin point
Done.