Tom really hit the nail on the head that the better designs always take this thought into account, especially as the gap between the stronger and weaker players continues to grow.
The greens that typically achieve this are the same ones where there are a variety of options in solving a question near the green, one of which must be a ground game option.
The first green that popped into my mind was the 4th at Kingsley club when the hole is at the front just behind the ridge. That is a really tough pitch to fly the ridge and get it to stop close, and you almost want to try to keep the ball on the ground and get it to just trickle up and over that ridge, which is the same play someone hitting a 3 wood would try to execute. It doesn't matter that this is a shorter hole either. That doesn't matter in most any case because there will always be someone hitting that type of club into any green. Golf is inclusive to skill level, and it is important to try and keep it engaging for everyone.
The Old Course and Chantilly also stick out to me as well; both of those are courses with testy greens and a strong focus on the ground game. That really seems to be the successful formula.