I'll answer to the question which course that is considered great you don't find great at all?
I have played the following top100 courses:
Valderrama, TPC Sawgrass, Harbour Town, Kiawah Ocean, Whistling Straits, Bethpage Black, RSG, Sunningdale Old, Pinehurst No.2
From these I am sure TPC Sawgrass, No.2 and Harbour Town do not belong. The first one - because it is in an awful condition during the winter and is absolutely artificial and contrived. The second just because it is built on a very average piece of land and is poorly kept. The third one because it is very monotonous, tight and actually a bit boring.