Professional looking and behaving water effects cannot be achieved currently in FPSC.
There are various workarounds and some reasonable results that can be achieved though its by no means easy. In fact its quite difficult to achieve even those reasonable results in FPSC.
Thats no different to many indie engines which lack professional features. A range of realy good water and other environmental effects are available only in a few.
Any increase or addition to the FPSC feature set may help a great deal - we just have to wait and see what comes along or make do best we can.
"I am and forever will be your friend"