In some ways having a bigger cock leads to more enjoyable sex for a guy and sometimes it leads to less enjoyable sex. I'm pretty big (8x6) and after sleeping with an embarrassing number of women, I have only experienced one partner's vagina feeling loose, which is usually great, as far as sensations for me goes. But I have slept with some girls who were just too tight: sometimes too tight for my comfort, and on occasion, too tight for their comfort--to the point of telling me to "take it out." Definitely not very pleasurable on my end. The same goes for deep thrusting with abandon: some ladies love it with a long cock, but for most, it can be a game ender should you unintentionally score a hard direct hit against her cervix. Guys with 5-6 inches can just get lost in doing what feels good and not have to constantly be aware of what angle you're going in with and how deeply you're planting it.
And while I don't know the acceptance/rejection ratio regarding anal sex with women, I'd wager to say that guys with telephone poles dangling between their thighs get a hell of a lot definitive "No Way"s than cautious "OK, but go slow"s. That's been my experience. I'd chalk that up as one for being less pleasurable having a big dick.
Blow jobs are another arena where it's better having an average-to-small cock. I can't tell you how many BJ's were cut short for me because of a mismatch between a girl's mouth size and that of my cock. I've also heard from many of my female friends who have almost universally concurred that while the big ones are arousing to look at, an average to small cock is more fun to play with in one's mouth, which translates to those guys getting more enjoyable BJs than those "gifted" with way more than a mouthful. And let's add to that the likelihood of getting a "deep throat" blowjob: I've met one girl in my entire life who could manage that with me.
Handjobs? Let's just say that if you're sporting a tree trunk, you view girls with small hands and long nails with equal amounts of trepidation and sheer terror.
But I'm not saying there's no gain in pleasure from having a big dick. If you're a caring lover--in and out of the bedroom--and make sure that your added size is providing your partner with erotic sensations she wouldn't ordinarily experience, her added pleasure makes for your added pleasure, both emotionally and physically. And having a woman just go to town riding your cock and violently coming from it, perhaps more so than she would/could with a less endowed partner, is a definite plus.