Padraig,
There are a number of holes that I could play all day long, but, on the same golf course, a par 3, par 4 and par 5, it would be the 6th, 8th and 18th holes at NGLA.
Others that come to mind all seem to enjoy good to great breezes off the water/ocean.
I think the wind, with its shifting direction and velocity, exponentially increases the interest factor.
Holes that fascinate me and arouse my curiosity include the 1st, 4th & 13th at PV, the 13th at ANGC, the 5th at Newport, the 18th at Seminole, the 16th at Boca Rio, the 8th at CC of Fairfield, the 9th & 16th at Shinnecock, the 3rd at North Shore, the 10th, 13th & 16th at GCGC, the 6th at Mountain Ridge, the 13th & 16th at Essex County East for starters.