Other examples of clever water spells I've seen over the past few years:
- Casting Destroy Water under an escaping rowboat causing it to swamp.
- Water Jet is extremely versatile. In addition to the many options listed in the spell description, I've often seen it used as a way to knock things off of ledges or tables.
- I've seen a couple of clever uses of Shape Water with steam, sometimes with natural steam (in a volcano) and sometimes with created steam (via Boil Water or Create Steam).
- A specialist water druid could maintain Breathe Water for free (skill 25). In his swampy homeland, he would commonly hide underwater using Water Vision to see what was going on above. Used this for ambushes, hiding from enemies, and spying.