J.S.
Every woman, and every pregnancy is different. You may simply be more sensitive in that area. Maybe you were swollen down there from something else, especially if you had intercourse prior to the procedure. Or maybe your doctor wasn't quite as gentle as he should have been. I've known several women who had the CVS done and they complained of minor discomfort. A couple complained of some light spotting afterward. A couple complained that it was pretty painful, but bearable.
You wouldn't get sedation if "most women" have mild discomfort, especially since in most instances sedation isn't good for the baby.