Cure, Cure II, Cure III, Medica, Medica II Wind (Green wind Aura)
Esuna is Water (Blue Water Aura)
Raise is Water (Blue Water Aura)
Protect and Stoneskin is Earth (Brown Aura)
Printable View
Fluid Aura, Esuna, Shroud of Saint, Presence of Mind, Divine Seal and Cleric Stance are the current water based abilities in CNJ/WHM arsenal. There's more than people realize.
I do believe people specifically are looking for attack spells with more cool water effects and not just blue auras.
Another fun fact, Holy has a Rainbow Aura when you cast it!
It very clearly has the blue water aura effect right as you cast it before the big shiny Divine Seal animation itself takes over. The only spell that doesn't seem to have a direct element animation on the character is Regen.
Edit: While not CNJ/WHM spells, Eye for an Eye and Virus are also water based.