The single stick was a huge limitation. A really good example for that is Zelda Skyward Sword. By the time that game came out 3rd person 3D had been around for three console generations and more than a decade already, so there was more than enough time to figure out how to do this.

Yet the camera was still one of the biggest obstacles in the game. It happened so often to me that the camera got stuck in some stupid angle and I had to use their clunky manual camera aim option to see what I needed to see.

BotW’s dual-stick camera on the other hand had close to no issues at all. Having a full stick dedicated to just controlling the camera really solves the problem.

PC, which is in many ways the gold standard platform for 1st and 3rd person games, has a very similar solution with the 2-axis mouse control being reserved for camera control.

Automatic cameras are always worse than manual ones, because guessing what the player wants to look at just works worse than allowing the player to control it directly.