Personally, I don’t mind special effects pieces at all.
An in-depth water simulation is calculation-expensive and at the end, it doesn’t really matter that much. (If you don’t look too close, that is. But usually we don’t.)
Having written this, I really would love to see a greater variety of “water fall special effect tiles”. Or, more precisely, special effect tiles that were actually meant to be used as water falls and not just some fountain FX that could be used as water fall in a crude work-around.
What about a narrow array of dripping water strings, what about a gentle fall like in the OP of the dedicated thread? And then, oh how wonderfull, maybe an even stronger stream, maybe a stone dividing the fall. With such special effects presets, I could live happily.