Vis a vis Stanford, I loved that hole when I play it as a student ion the 60's. Expansive view, the thrill of a highly elevated tee shot, the challenge of hitting the ball solid to, fiurstly, get it airborne, and secondly, to thread (if 50-60 yards of fairrway involves "threading") your way between the bunkers right and left, then a death or glory second shot through the narrow defile towards the green (or a lay up, if you were as smart as the admissions office claimed you to be). The best aspect was the (NLE) rickety wood and steel bridge that carried you above the traffic and across the road onto the warm turf of the fairway. Now, getting back to the 21st century....
Prestwick! You must be mad, Chuck. Easily one of the top candidates for best opening hole, but I do feel your pain.
Chris--agree with you re: both Hoylake and Muirfield. The former is a great hole when it plays in the Open routing as #3, but as an opener, far too goofy. The latter is arguably the finest opening hole in the world of golf. Also agree with you and others regarding NGLA. I could play that whole every day for the rest of my life, if they would let me....