Not sure if this counts, but I once walked the UNM South course--where Phil Mickelson won the college golf championship--with a buddy of mine who was playing.

The best looking course I have ever seen in person is Shinna**** on Long Island, where the US Open and PGA have been played. If you go east to west on Long Island, you have no choice but to drive by it as there are so few east/west roads.