As it was told to me, size matters up to a point. After that point, pleasure is not enhanced. A big one may be a turn on to look at, but it is not more pleasurable.
I'm only relating what women have told me and I'm certainly in no place to argue with them.