In ancient Greece, a large penis was considered laughable, by the men at least. They had institutionalized man-boy love, so maybe that had something to do with it.
I've never run across any indication of what women prefered. Maybe well-to-do Greek women had to purchase foreign slaves in order to make up for the deficiencies of their pencil-dick husbands.