This functionality, at least for FSD, has changed over time. A year ago, it didn't slow down. It would just get in a curve and panic. (Tell driver to take over)
But then it started slowing a little, and still had quite a few problems and would panic.
A few months ago, it started seeing and anticipating curves and slowing down, to the point that, people called it grandma driving. It was really slow going around the curve.
Today, last I checked (it changes with software releases) it does see curves, it does slow down and it doesn't do a bad job of it. From watching behavior, it seems as if this might be one of the times when it is looking at the map for clues as well as the cameras. It feels that if the map shows a good curve, then the car will anticipate a lot more. But even if it doesn't the camera will see it and slow the car down.
So, for me, today, it's probably handling 99% of the curves "correctly" there are still a few that it has issues with. I've still seem some center line incursions on really curvy roads, but even on those, the car has slowed itself down significantly.