Are we talking about which type of greens (fast or slow) we prefer/like? Or are we talking which is going to produce...in the long run...higher or lower scores? Regardless of which type you might prefer to play, in my opinion...
If you talk about just green speed, not bumpiness, etc., players of all caliber are going to take more putts in the long run on faster greens. It's almost a mathematical certainty. Pros may not play truly slow greens very often, but when they do, they demolish them...no fear of going past too far, cutting down the amount of break they have to play, etc. A good part of the difficulty of top courses/top tournaments is the lightning speed of the greens. Take that away, the difficulty is reduced dramatically.
The principle would only be magnified for lesser-talented golfers.
(And fred53...I totally agree with you about some of the silly pin positions on the executive courses. Some would be basically "illegal" by any accepted standards.

)