Water injection systems were VERY common in the '60s and '70s on naturally aspirated engines. You wouldn't believe how common it was for guys to be running 12:1 pistons on the street. And, yes, 3/4 race cams, dual quads, tunnel rams, Thrush mufflers (or Purple Hornies) and chrome everywhere.
It helps to understand how a water/methanol (or just plain old denatured alcohol) works. The one obvious side is where the mix is injected into the intake manifold. We know this helps to cool the intake air through both the latent heat of evaporation, which means that heat in the system is being removed just through the chemical process of evaporation of the liquid, and the presence of a cooler liquid medium that helps to absorb heat even though it has not evaporated. The other way the mixture helps is in the combustion chamber. Here, the same evaporation process is taking place but the affect is more dramatic. As the piston is rising, whatever is in the combusion chamber is being squeezed. As you know, when you compress gasses, it raises the temperature. This heat vaporizes the liquids in the combustion chamber and in that process, latent heat is being removed making the fuel/air mixture less susceptible to abnormal combustion.
Water injection has never gone away. It's just that the circumstances that brought them to prominence kind of passed by when we knuckleheads quit building 12:1 street engines. The systems out there, like the Snow system, got new life with the advent to boosted systems. But they do make systems for naturally aspirated carbureted engines and they work just the same today as they did 70 years ago.
Here's a useless fact: B-52 bombers use water injection to increase engine thrust. Those eight turbofans hanging off the wings are what are called volume engines, meaning the thrust is based upon the volume of air going through the engine. And just if you were interested, a Turbojet is a pressure engine, meaning thrust is a consequence of gas pressure. One way to increase volume for the Turbofan is to use a liquid that vaporizes. In this case, the B-52 uses distilled water. It's injected into the engine and the volume difference between an atomized liquid and a vapor is roughtly 600 times. So you get more thrust in the process of the rapidly expanding vapor.