Women may prefer different sizes for different reasons at different times, so chances are very good any guy is someone's ideal for the relationship type they are seeking.

To maximise the chances of receiving the sexual benefits it makes sense that women might prefer a larger girth penis that brings the clitoral glans closer to the friction point and also will stimulate the crura of the clitoris internally more.

There is a cost with a larger phallus.

All intercourse causes tearing and pushes bacteria into the vagina. A larger phallus probably causes more tearing and may push more bacteria into the vagina: not a good long-term option.