As a woman I don't really care.
Also if it's a medical procedure that would end up helping you or making you more comfortable in the long run, I'd say it really doesn't matter what a lot of other people say about it, nor even what female partners would say about it. If your partner loves you and wants you to be comfortable they should probably be supportive of the procedure. Even so, sex is still probably going to be pretty awesome feeling, because...well,...it's sex?
If you were just doing it to do it, then...I dunno man,...I dunno.