I know I'm a dude but I have read on this alot and I think the consensus is size is not that important to MOST.
Also just because a woman has sex with someone with a huge cock does not mean that a lesser size one will no longer do anything for her.
If that was the case I would be in BIG trouble

!
We have been with men who have been huge and even in the same sexual event my average warrior has gotten mrs naughty to her happy place just as well as King Kong.
I think all of us men who fall into the "Average" category are a little self consious once in a while about our size. But I equate it to how some woman are self consious about there body when they look damn fine!