Yeah its really not a well known fact lol. Rotations are created using camera tricks where they tilt or pan the camera depending on the player movement. Check out this cursed gameplay with the camera tilting removed: www.youtube.com/watch?v=JiH8...
youtube.com
Super Monkey Ball 2 but without stage tilt (full playthrough)
YouTube video by sock puppet