Pff that liquid in Horizon Dawn looks just too good!
In Unity using the Amplify Shader editor there is also a preset in the examples with this effect: