From a woman's perspective... all the conversations both I and my wife have had with women have suggested that length doesn't matter at all and width matters up to a point but "too big" is MUCH worse than too small. In fact, several said they preferred small, because otherwise it could hurt. And some of the other things these female friends said to critique their lovers in this kind of girls-only chat? They were not pulling any punches.
(I actually know a cis guy who's no more than an inch hard, and less wide than a finger. He had no trouble getting girls, and he got married last year.)
From *this* woman's perspective, someone who knows what they're doing is the most important part!! I can get a plastic boyfriend in any length and girth I want; I don't go to a lover for that.