Thought it'd be more interesting to frame this in a per generation context vs GOAT otherwise it'd probably be a bunch of Horizon: Forbidden West or Sea of Thieves posts (which are valid!). Of course this isn't just down to appearance but types of effect like ripples, wave simulation, how smaller bodies of water vs oceans and streams. For ripples Insomniac was on some other shit than most devs during PS3 gen, it looks kinda exaggerated today but for the time this was pretty mind blowing seeing 3d ripples. They had this going on in R&C as well as Resistance.
View: https://www.youtube.com/watch?v=JyuY3-SLuDA
Nintendo continues to have some of the nicest looking water shaders for shallow bodies of water, Pikmin is the perfect showcase for this:
View: https://www.youtube.com/watch?v=7AA-j5C33pk
Morrowind in 2002 was really impressive relative to other games out at the time, and when it rained and seeing all the ripples on the surface was a vibe:
Your picks? And obligatory:
View: https://www.youtube.com/watch?v=JyuY3-SLuDA
Nintendo continues to have some of the nicest looking water shaders for shallow bodies of water, Pikmin is the perfect showcase for this:
View: https://www.youtube.com/watch?v=7AA-j5C33pk
Morrowind in 2002 was really impressive relative to other games out at the time, and when it rained and seeing all the ripples on the surface was a vibe:
Your picks? And obligatory: