So, let's choose the best water ever in a game... Before you people bring over Crysis and Virtual Skipper, the best water means best looking and best interactivity and the the system specs where the game runs...
For example, Mass Efect water looks good but objects pass through it without leaving any ripples or something!
Crysis has good looking water but the interactions is just some drop tracks designed and not actual in-water ripples like the ones seen on Gears of War 2 and Uncharted for example...
So for me, the best water effects is.....
...
...
..
Starfox Adventures for Gamecube!
Who played this game knows what I am talking about. The water effects on this game kickass!!!!!!
It can stand nowadays with many HD games and have better water effects than majority of those games!