You asked what's the ideal terrain is... IMO, the more variety, the better, so...
terrain that provides the most variety is best. That property would allow you to use elevation in several ways:
1) A few holes with BIG uphills and downhill tee shots and upshots to the green, not just 10 ft elevation change, but something that really makes you suck wind getting up there.
2) Moderately rolling terrain on a couple of fairways.
3) Some pins on small hills, slopes, and near drop offs for rollaway risk/reward
4) A couple of flat fairways, maybe even some that play flat, but drop off parallel to the fairway, so elevation may be a factor.
5) plays across gullies, and over rises to a blind pin placement.
A couple densely wooded, a couple of long open holes with just a few well placed trees to remove a line or guard the pin, some lightly wooded and some moderately wooded.
If you have a piece of property like that, CALL JOHN HOUCK IMMEDIATELY!
^ since this wasn't one of the poll options, I selected Very Hilly, Moderately Wooded.
Edit: just realized, I described Flip City.