The FS2004 Water Effects Slider works backwards.

Wait until you see what it is supposed to look like, its really an
astounding effect!

To get the effect: Options - Settings - Display

Max out the Terrain detail: land & water (all the way to the right)
Water effects: None (all the way to the left)

Go flying and bring your bathing suit.