Root Canal: As fun as it sounds?

I have to have a root canal and have heard horror stories. I understand that the dentist drills out the nerves in the root of the tooth and then cleans it out and fills it with something or other.

If you have had a root canal (or are a dental professional and actually know what it is you do to people), please describe and tell me the general level of pain to expect . . .