Experience is only gained by trial and error in this hobby, because most of use work alone.
i found Woodland Scenics Water Effect stayed sticky and soft. Anything touching it perhaps a boat will sink in so when removed the shape was left in it.
Eventually i used the cheapest stuff for my needs.
It seems that glass like clear tops on Lakes and rivers seem popular but prone to show the slightest defect. Whereas rippled flowing water effects are less of a problem.
My advice is prepare some samples using the same stuff if need be,but differ the process of creating them,and then after make your choice.
Differ the process on how you achieve an end,by the way you prepare and paint your bases.
My recent adventures are well covered in my topics which are still ongoing,and although fit for my present needs, however for the many,not for theirs.
i have in the past used coloured Varnish, Clear Varnish, P V A Glue, Silicone in Tubes,and Water Effects as mentioned above. Now i have used Hodge Pudge! A Form of P V A Glue.
i watched a guy on You Tube , do 7 pours of mixed up Silicone Resin over a period of weeks,
each pour taking 72 hours or more to cure clear upon a piece of board about a foot long and 4 inches wide. The Cost Was Crazy! I felt like advising him to use a sheet of glass!
Often is the case simplicity gives good results.
i wish you every success in doing your water effect.
BB