I was getting over bright images when rendering out and banging my head against this problem for days, I solved it by changing settings in my CineCameraActor.
In Lens > Exposure, I checkmarked “Metering Mode” and set it to Manual. I then checkmarked “Exposure Compensation” and set that much lower. In my case -5 worked.
My rendered image was now similar to what I was seeing in the viewport. Not exact, but at least workable.
While these settings made the final image look decent, all the passes look UNDER exposed.
For render passes, I duplicated the CineCameraActor and set its Exposure Compensation to +3.5.
Again, this setting may vary for your project.
I still don’t know what Unreal thinks a VFX workflow is supposed to be, but maybe this helps whoever reads this.