Pain is totally subjective - look at what marines do as basic training, compared with what the rest of us think is unendurable.
i have not had it done, but would imaghine the pain is intense, but short-lived, the only way to find out is to try it. it has to be worth a little discomfort to present an image you are happy with.