It's not about having dumb cameras, it's about enjoying being able to walk in one direction while looking to the left/right/up/down etc.

First and third person viewpoint games often require a lot of camera-adjusting if you want to get the best out of them, and good games make use of the bumper/trigger buttons for regular usage and save the face buttons for situational events. A good example - for me, at least - is Batman: Arkham City which I've been using a lot lately. To move around, I use the left analogue stick. For sight adjustment using the camera, I use the right analogue stick. This allows me to move around the screen with fairly fluid motions, a useful thing in the game. The buttons I use in fights, while the gadgets are primarily controlled by the bumper/trigger buttons.

FPS games naturally require a massive amount of camera control considering it's how you target things, and games like Uncharted benefit greatly from this, too. You still use buttons for things like reloading, but it's not as vital. JRPGs with camera control allow for aesthetic rewards when you can control your camera angle while moving around, such as in XIII and XIII-2. Obviously in games that have no camera control, the right stick more often than not becomes far less important.

What games do you play that require you to be constantly pressing ABXY/XOTriangleSquare?