I doubt is there will be much agreement on this topic because there are so many different opinions on what makes a good site. For example, I completely disagree with Jim Franklin that the mountains of NC, and in particular Wade Hampton, is among Fazio's better sites. Wade Hampton is very much overrated precisely because of flaws in the site. The course is located in an area that has one of the highest annual rainfalls in the continental U.S.. Consequently, the fairways are soggy just about all of the time. To compound the problem, several holes (the 7th, for example) are built just a few feet above solid rock making drainage a big problem. The course probably has more drainage grates in the fairways than any I know of. Furthermore, because of the weather, the course is playable only about half of the year. In my view, as a minimum an excellent site must offer decent drainage, be playable year-round, not be overly dependent on the whims of the wind (the Ocean Course), and not require 2 miles of cart paths (Champion Hills, a decent Fazio course on a terrible site in western NC), not have an extreme amount of water, or require beaucoup blind shots.
Given MY criteria, I judge the best sites to be in sandy terrain, moderate climate, some-but-not-too-much elevation changes, and not too close to the ocean. Bottom line for Fazio, that means the NC Sandhills (Forest Creek), and various North Florida sites (World Woods, Pablo Creek, and Johns Island West)
For Pete Dye, among those I've played, the Golf Club. The Honors Course enjoys an excellent site, if they had not screwed it up with that very un-natural looking, man-made pond located in the middle of the course.