Not only does the water cool the turbine, but the water vapourises incresing the volume, consequently the pressure and thus the thrust. The design of the engine is important - if it is close to the surge margin, then obviouslty this is not a good idea.
The Harrier/AV8B has about 40 secs worth of water injection for hot/heavy hovering.