My dad had one years ago.  I too had heard they were painful, so when he got home I asked him and he said it wasn't bad at all.  I'm sure a lot of variables go into it:  the one doing the procedure, the pain meds used, the pain tolerance of the patient, etc...