The game also has a HDR Scene Scale slider that adjusts the mid point (exposure shift towards dark or light). Set the slider to middle position or adjust to your preference.
Also note that the peak brightness in the pre-render CGI cutscenes of story mode is fixed at around 450 nits, which will cause the cutscenes to look dim. This brightness is not adjustable in any way and does not depend on the HDR settings.