Static camera angles, as well as tank controls, I have never seen inherently compromise gameplay. They are not archaic, as I see tossed around. It's just a different approach, like isometric games. RE4 has tank controls for instance. Not once was the game compromised by this. Neither did fixed camera compromise the games that utilized them.
RE6 however did have fixed angles at certain parts (Ada's campaign a bit more frequent than the others). I disliked some/most, such as the spotlight avoiding segment. However, this didn't have anything to do with the fixed camera itself. It was rather that it was just poorly done, as were most of the instances. If they set the angle higher in that part for instance, it would have been fine.
It's something that requires commitment at a design standpoint. If you don't design the level, encounter, and whatever else involved around it, it's quite unforgiving. Compare Dino Crisis 3 with 2. Both have fixed cameras, but one followed the design through with it in mind while the other did not.