Darren,
Most people think of it the other way around with Scottish courses. They are designed to play in the wind and can be quite defensless in lesser winds. Of course, in a Caddyshack type gale, almost any course will become difficult to score on, without the devine intervention.
Most courses are designed in a prevailing wind in mind - Florida courses usually are concerned with resort season winter winds, Chicago with the SW wind of summer, etc. Texas and Scotland are tough - there can be a 10 month season with almost directly opposite prevailing winds. Some assumptions must be made, which, if made to maximize play in the prevailing wind, makes it very difficult otherwise. The other option is to provide more generous options to account for different winds, at the expense of reducing interest in the normal wind.
This often means (to me) bigger, rounder greens that can be attacked with a hook or a fade, for example. Designing strictly for the prevailing wind, a longer narrower green angled (and contoured) in the direction of the wind, and bunkered on the downwind side makes execution pretty interesting, with less room for error to hit the green.
I think the wind conditions could be negated even further through match play. Who cares if you shoot a 78 (or whatever) if you have an even chance in difficult conditions of winning some holes.
Jeff