Well, I have zero experience with standard and vivid modes, so I can't really comment on this. The most accurate modes for C9 are the ISF dark mode or Cinema mode for SDR and Cinema or Techinicolor mode for HDR. For DV, again it's Cinema. Although, if you want the image to really pop, other modes will suit your taste better. The accurate warm 2 setting can seem too warm for many initially as LED TVs lean towards blue quite a lot.
Anyway, do note that it's the same panel with same color gamut. You can tweak settings to match in both according to your preference. Upscaling is win for Sony though, even motion, but since I have been using LG, not once have I thought while watching, I wish this was better. It looks darn good.