Green sizes are a wonderful way to vary a course from day to day. Particularly length of greens which give more pinable locations that cause a different club for ab approach. As I pointed out I just played the European Club which has the 127 yard 12 the green which certainly even accounting for roll out easily has 3 or more clubs difference depending on the pin location. Now that is extreme but having more length in the green forces a different club and also brings in lag putting as a more valued skilled.
Not all courses have this luxury but those that do I enjoy.
I think having a lot of big greens is boring. Sure, there's more variety of clubbing, but there is a lot less variety of recovery shots around the green, and a lot more 50+ foot putts.
I do not mind that so much at The Old Course, because the double greens are mostly wide and shallow, and having a long putt is usually the result of aiming further away from the trouble on the left. In other words, it's strategic. But big greens are usually not strategic unless they are closely guarded in multiple spots.