Excellent topic: some comments
Augusta National: While most here would probably like to play it from the new tees used this year, for me, I'd go to the members tees or something like 6500 yards, otherwise every par 4 would be a driver, 4 wood and wedge, no fun in that.
Oakmont: While it is most probably a great est of golf and a proper U. S. Open Site, my one round there was not fun, I just don't like to hit driver, chop a sand wedge out, etc
Pebble Beach, Pine Valley, National, Cypress Point,St Andrews, Merion: Every round I had on these courses were fun.
Ditto some of the oddball courses like Tobacco Road.
More fun courses like Black Mesa, Lakota Canyon, The Quarry at Giants Ridge
Winged Ft, another great test of championship golf, but not fun, but Yale, lots of fun and a good test of golf.
Cog Hill is fun, but Medinah #3 is not.