I understand that at a typical Roman orgy, it was regarded as very rude indeed to have a large prick, because they were so uncomfortable for so many people in so many places. It is (I believe) only where and when sex is regarded as largely about male domination of the female that the large prick is regarded, by the male, as superior.
Having said that there is one (and as far as I know one only) of my daughter's female friends who is obsessed by size - and most of her female friends take the mickey out of her about it to the extent that even, I a male of an older age group, have observed such mickey-taking.