Easily From Dust. Has any other game actually tried to simulate water volume? I spend hours building up dunes then washing them away again, letting reservoirs fill with water then watch the dam burst.
Spin tires does very well with flowing water pushing your truck around and mud deformation when you struggle through muddy roads and puddles.
As for just looks, Uncharted had some good water effects, waves and flowing water. Drive club looks amazing in the rain. Death stranding looks very good in the rain and the water lapping up on the beach looks very good as well. Plus it has many flowing creeks.