I understand the nature of the question, and love great golf sites.
In reality, the best site has some of those qualities, and is close to its customers and reasonable utility extensions.
Yes, there are 50-100 destination resorts that we all love, but visit once, the real distance issue in golf is the distance from front door to first tee. You can deal with the rest and produce a decent golf course. Oddly, that site at Inch takes miles to get to.....I wonder if that is where the saying came from?