I'm in the same boat. The surroundings (I like the wet rocks) look better than the water.
I photographed a waterfall in Madagascar's Mantadia National Park and tried a lot of different settings (no stacking, averaging, blending, etc.). My favorite result, posted here, was at 1/20 sec.