I think you have to examine this ? in the context of putting surface vs green complex. Also what is the accepted definition of Big and of Small? Also, the shape of the green can allow a green with alot of sq. footage but plays small due to narrowness.
As for maintenance, one of the biggest grip you get from supers is big rolls or nobs in greens - what you guys call contour. These tend to dry out faster and need to be hand watered. They also develop localized dry spot. Also because they dry out faster, the water collects at there bases and in swales so the consistency in green speeds fluctuates.
Personally, I like to average my greens at 6,250 sf. This allows some in the 5,000 - 6,000 sf range and others in the 6,500 - to over 7,000 sf. I've even done some 15,000+ monsters that are really 2 greens in one.
The size/shape/contour also has to reflect what it is you are asking the golfer to accomplish along with what the surrounds, topography and wind conditions are. Is the green elevated or fairway level? Is there short grass or long rough off the green, can you bonce it in or is a carry required?
Like most of the questions posted here, there is no black/white, right/wrong answer here. That's the beauty of golf course architecture - everyone has there own preferences and peaves. If everyone liked the same thing, we'd all be chasing one women.