I still like everything with water done by the great Jim Sachs the most.
That map of England in Defender of the Crown, Ports of Call, and all his studies done for that 20000 miles under the sea game that never happened.
See this for example:
http://amiga.lychesis.net/special/Co...Sea_Beach.html
Beats any other water effect on the Amiga, imho.