I'm trying to understand how to color manage to get consistent results but I'm failing spectacularly at it currently. For reference I'm using Cinema 4D with Redshift, working with ACES. On the default setting, Redshift is set to use ACEScg color space, displaying it on sRGB, and applying ACES 1.0 SDR Video on it.
When I render and save it as a PNG, and then open it up in Photoshop of Affinity Photo, it looks completely different. I have Photoshop set to ask me what profile to use whenever it opens a photo - this is part of the confusion. When I save an image off Redshift render as a PNG, and I open it up in Photoshop, what color profile should I choose? From what I've read and watched, I should choose the color profile it was saved with - which in this case is ACEScg, so I should choose that on Photoshop right? Except when I do that, it gets super bright and looks nothing like the render screen.
What exactly is happening when I save an image off the render? Is there a color profile embedded/baked into it? If so, which one? And when I open an image in Photoshop, what profile do I need to use - the one the image was made with, or just sRGB?
For reference, my display is a Dell U2414H, and I'm using Dell's ICC profile for this specific monitor (I can't calibrate it with external tools because they're just a tad bit too expensive for me right now).
EDIT: Additional info. If I open the image and set photoshop to not color manage, it opens as an untagged image. Even then, the colors are still somehow different from the render view and within Photoshop.