Uncharted 2 water reflects and refracts properly, flows, and ripples when the player(s) runs through, in SP as well as MP.
But you would rather have R2 water that looks more like jelly, doesn't really behave like normal water, and worse yet, it visually represent water poorly with no reflections and the distortion is over-exaggerated, like jelly, and the so-called "fluid dynamics" doesn't factor into the gameplay at all, they never really took advantage of the buoyancy in any meaningful way, if you want to complain about static water, R2 water is the definition of static water, there were basically static pools of water. The player is enjoying none of the benefits of their implementation, yet you would prefer a feature that does nothing to help the game and hurts the game's overall look when reflective water this generation is an expected feature.
As a GRAPHICAL feature R2 water is a failure, the game doesn't look better because of it, it didn't do anything as far as the gameplay is concerned and processing power could have been better spent elsewhere.