If you are going for hyper realism, especially in animation, you need a render that allows separate passes that you can later on retouch in either 2D such as Photoshop or 3D/Motion compositor such as Fusion. That's utterly important for our school anyway. So far we've figure out few workarounds thanks to VW's extremely flexible export options.
Here are few renders we use
Keyshot - great for fast and quality interior shots - great for hyper realistic cloth material render thanks to new Realcloth material - superfast with RTX GPU support - Supports passes (limited compared to other renders)
Vray Next - for very obvious reasons if you are into product or presentation industry
Octane - the best I've used so far personally - ultrasonic fast - unbiased - PBR - volumetric lights and scattering in blink of an eye - render out all the passes you can imagine - because it's ultrasonic fast rendering custom camera motion is so simple.
I'm pretty sure all three renders would pick up VW as soon as VW opens up. Happy to hear about Redshift, even though it's significantly different from Octane in workflow but we would never miss out on the opportunity to learn new tools