I still say that if you want to play an intense/stylistic action game like Ninja Gaiden, you're going to have to work around the camera. Once you do that, it becomes functional enough and allows you to enjoy the game.
I mean, I just CAN'T imagine how you can have a perfect camera for games like Ninja Gaidene or Devil May Cry 3, the action is fast, the enemies are in high numbers, and the combos are flying off 60 frames per second, all stylishly and super fast. A perfect camera is not gonna happen.
Same thing to say that every second of an RPG will be exciting. Just not going to happen.
There are certain downsides and upsides inherent in each genre.