Gave it some more tries now and it seems that my test scene with just boxes and teapots for segments and a squiggly test spline was hard for RC.
Sharp turns in relation to the segment size seems to produce situations where the rotations "flips out". But just a bit of curvature makes it not completely aligned to the same orientation.
It's maybe mathematically correct, but not the expected result from a user perspective (the same global rotation for every segment). Good news is that with a long smooth spline, results seem better so far, and this is more similar to my actual use case. Will try with my acctual production scene and get back with my result.
Attached a screenshot and also my scene if anyone wants to have a look
