In your character blueprint, you’ll need a spring arm. In the 3rd Person tutorial they call it CameraBoom. As you can see in the image, I rotated it to view the character from the side and extended the spring arm to 800 units.
In the character event graph, I set the spring arm to use absolute rotation. Now the camera will follow the player but won’t rotate when the character does.
That is all you need to do to get a camera like Little Nightmares uses.
Just for clarity this is the movement setup I was using.