The workflow I used can be watched here, although stop when it gets to After Effects. He admits in the comments he got it wrong but you can use Andrey Lebrov’s excellent tutorial here.
As you can see, the difference is pretty huge. Whilst it won’t save a poorly designed/made shot, it can add that extra 10% in terms of realism. It’s just up to you as to whether or not you want to go through the somewhat tedious method of adding it to your workflow. For a large project I’m about to start, I’m planning on using it although I will be doing some tests in Octane to see how its native support compares to Redshift’s somewhat hacky approach. Come on Maxon, please add this.