I have never been convinced that wild greens are inherently more interesting than gently rolling ones.....I think a course with subtle variations in green contour from one hole to the next (like 1.5%, followed by 2%, etc.) and a few greens where the contours are the main line of defense (yes, I know some think every hole ought to defend par at the green mostly.....) strikes the best balance and presents a good putting challenge.
In general, with a few exceptions, when you have to worry about de-greening a putt, or have to hit the hole to stay on the green, the green (or at least that pin position) is ridiculous. I don't mind that possibility once or twice per round, and some would tolerate it less, but what purpose does that panic/fear serve otherwise? I agree too many green contours are designed down to the lowest common designer of "I should never putt off the green" mentality.
I suppose a course where most players (read, mid handicap and above) are mostly and routinely 3-4 putting would probably fall in that category by default. Agree speed makes more greens ridiculous than any other factor, but have always found that sooner or later, your green speed will increase, and thus designing perhaps a blander green for normal speeds to make the max speed reasonable, is usually called for.
While some would argue that may preclude "great" design.....again, if form follows function, I am not sure I agree that overly wild greens, generally only for the sake of being wild, are really that great.