Renal colic

Anyone ever have a bout of this? How bad is it, really?

Yesterday I had what I thought might be a kidney stone. On medical advice I drank a fuckton of water and now I basically feel 100% fine, but I have developed a morbid curiosity about how painful it could have gotten - or might get, if it comes back.