Pete Dye has exhibited excellent design and engineering at places like TPC Sawgrass and Old Marsh in Florida, and PGA West for example, where very good golf courses were constructed upon sites that exhibited very little, if any, potential for golf - ie. uninteresting topography, poor soil conditions: characteristics that generally produced poor to mediocre golf course designs.
Coore and Crenshaw's Sand Hills, and Doak's Pacific Dunes for example, are courses laid out upon landscapes topographically suited for world-class golf - ie. interesting topography, relatively ideal soil conditions: characteristics with potential to produce world-class golf course designs.
Trust me, someone could have screwed up designs at both Sand Hills and Pacific Dunes. Coore and Crenshaw, Doak and co. didn't. That's excellent design as well, over ideal properties.
To answer your question, JWL, some sites can only produce "just a pretty good golf experience", yes. Unless, of course, an exceptionally talented golf architect is in-charge, a la Dye at TPC Sawgrass. That is GREAT golf course design... anything less is either the result of lack of money or talent, or both.