I actually get a lot of wax build up and have had this done heaps..

It doesn't hurt, just feels weird. It is warm water pushed through a syringe to push the wax out.

Most dr's refuse to do it if you have an infection (this is mostly when it will hurt).

Personally I haven't had any ill effects from it (but as a PP mentioned, it can perforate ear drums).