The most impressive water I've ever seen (taking time into account, so old games have a chance) was in Baldur's Gate: Dark Alliance, on the PS2.
Their water was amazing for the time, and on the weakest console of the day.
Despite all its faults, Lair's water was actually really good as well.







