Just as the British Isles owes the sandy character of it's soils to glaciers, so does the upper mid west of the U.S. Since glaciation extended as far south as Kansas, the states of Kansas, Nebraska, Iowa, S. Dakota, N.Dakota, Minnesota, Wisconsin and Michigan are all good candidates. (There's an excellent book on the geology of British Isles courses. I can't remember the author right now)
One trick is finding the locals where glacier edges existed, called terminal moranes. At these sites, glaciers tended to melt and drop larger deposits of sand and gravel. Also typical of these areas are formations called eskers-elongated sand hills- which frequently are found grouped together, forming series of parallel valleys-ideal for golf course routing.
There are sites in N. Minnesota with the most spectacular sand-based topography you'll ever see. I've routed theoretical courses over one of these sites many times over the years but the demographics of these areas limit the types of golf facilities that are possible. Upscale courses in sparcely populated areas can only survive as resorts or private clubs. the courses can only stay open for 6 months a year.(But when it's 100* in Texas, it's 75* in the north woods.)
How 'bout those TIGERS?
Texsport