Also Morrowind when you first get off the boat at the start. I saw it for the first time a few weeks ago and thought "that water looks nice, even today". Back in 2002 I imagine it would've absolutely blown people away.
And side note, this subject reminds me how astonished I was when I first saw the water in Wave Race 64 (mostly its physics / general motion quality).
I still remember N64's Wave Race (still own it!) as a graphical marvel.
I would pay big money for a ship sim that looked like that!!
GTA5 water and underwater stuffs is amazeballs.
Witcher 3 looks good just started that up last night.
Crysis 1 with mods is great too.