You know what's weird, I thought Isaac took up as much of the screen in that video as the characters do in RE6 and yet no one was complaining about the camera. Of course I could be wrong, but they seemed pretty similar.
Dead Space is a hybrid camera system. For most things it functions similarly to fixed FPS camera: player control is FPS strafe style and the camera is bound to the players perspective, you can see Isaac's upper body turn with the camera, where it goes.
However, if you turn the camera far enough it will break free, allowing the player to rotate it around the character.
So the system is like some weird lovechild of free camera and FPS camera... and it works incredibly well.
Also, the player movement has an impact, since the DS FPS controls allow for strafe walking all the time. Something you cannot do in RE6 unless you aim.
I'm used to RE6 now and like the game. I won't say which is better, because they both work well imo.
If I had to pick the best... well there is no contest. TLoU blows everything else outta the water. imo