If the person doing the waxing is good then it should a manageable amount of pain. The wax should be hot enough so it doesn't pull when applied, yet not burn either. The should work quickly and the good ones know to immediately lightly slap their hand on the spot they just waxed to minimize pain.
If you can get sugaring anywhere, I highly recommend it over waxing. Less painful, quick, less risk of irritation or bumpy skin afterwards.
Having said all that, I cannot recommend a place, Living Fresh spa offers both but they're just OK and pricey. I get my sugaring done in Santa Monica usually.
If you find a good place let me know!