Oh Mr. Craig, you may have just touched on something I consider very important with your above comment...
It seems many people don't enjoy playing hard "Championship" stlye courses (IE Butler, Medinah, OFCC, Hazeltine, Oakland Hills, etc...) which raises the obvious question: if no one enjoys playing them then why are they "great?"
Two "great" courses that I have played that I, in fact, wouldn't enjoy playing every day are Kiawah Ocean and Seminole. Why? They are too damn difficult for me to play. Seminole the day I played it had 20 mph winds, BRICK hard greens stimped at 13 with ridges and slopes feeding balls into bunkers. I've played Kiawah Ocean in 20, 30, and 40 mph winds. Each and every time I've played it, it has been amazingly great and fun...but mentally exhausting. So, I wouldn't want to play it/them every day as they are too difficult for my current skills.
HOWEVER, if I played them everyday there is no doubt about the fact that my golf game would improve significantly and my course handicap would travel quite well. And if I was a tournament player, I think I would become a fierce competitor and a threat to win at each and every course I travelled to. (Assuming I could survive the demoralization what would occur at the beginning of my every day golf at these types of courses).
I believe this is a BIG factor in many courses being defined as great. They are great tests of golf. Only the best golfers can score well on them. In fact, I believe many of them were built for that specific purpose...to take golfers to another level competitively. Furthermore, I believe Oakmont fits that bill...and I am sure a few others as well which were built right around that time.
So, I think GREAT courses fit into a few categories. Perhaps two of them being, playable by the high handicap and a challenge for the scratch man...AND...courses that are simply sheer tests of golfing skill. Play on the testing courses and your game will improve significantly over time. Play on the more fun courses and your rounds might be more "fun" less stressful, but don't expect to have a great traveling handicap when visiting the likes of Oakmont, Medinah #3, and the like.