With what DoesntChristmasDragOn said to mybumpsaboy about the water not necessarily making the pain go away...
Thinking about it I reckon that although you're right DGDO, it did help me loads with the pain but I think it wasn't because it made the pain go away, but because on dry land with feeling so uncomfortable and heavy, the contractions felt like they were "bearing down" on me mentally and physically and I felt overwhelmed - whereas in the water, yes it hurt, but I didn't feel so overwhelmed by them because in other respects I felt light, and warm from the water. It calm me enough to cope well, whereas out of it I was panicky.
On dry land everything I tried to lean on /sit on felt hard and cold in comparison. Does that make sense to any of you who've done water? I don't know if it was extra helpful to me with having a back-to-back babe... Really felt like the water was like a big hug.
Def agree that G&A can get you there, never thought I'd go through transition without it but there you go. The key, for those yet to try it, is to take three of the hugest breaths of it you can, before the contraction hits, and then you (or certainly I) just look like Homer when he thinks of donuts... head on one side and tongue lolling out without feeling it so much!! Lasts for the amount of time you need then you're normal-ish again.