Indeed, Turbulence is nice, or even Cellular if you want some rough sea ... But you can't animate the flow of the waves then ! ;) In fact, it depends on your needs . But for anims, you can't find anything better than Water:Waves in Carrara .