Sorry to hear that. Quite prevalent in my direct family, and I have a holy fear of it.
The worst thing I've ever suffered trough was probably a (*googles*) Inguinal Hernia when I was just about 4 years old. Don't remember anything about it though, so perhaps it wasn't all that bad. Other than that I had a rather nasty fall when I was 10 or so which nearly tore off my lower lip, but even that was more of a 'look shocked at all the blood' type of moment than one of excruciating pain. On the whole I've been spared any real pain so far. Let's hope my luck continues.