The problem in your question lies, as it commonly does, in the definition of best.
I am a short-hitting, crooked, eight handicapper with a pretty darned good short game.
I like golf courses that let me find my tee shots and play them up in the vicinity of the green--where I can practice my true craft.
So, I like 6,000-yard courses with wide fairways and not too many trees or deep rough. And if I am allowed to be picky, I want small greens that lie comfortably on the land--not too many goofy mounds around them and please spare me the artificially elevated variety.
So some of my favorite courses aren't what you'd call great. But I really like Albuquerque CC, and it's not great. I also like Winfield (KS) CC, where I played today, and no one is going to mistake it for greatness.
Others might be great, Brora for instance.
Dornoch is supposedly great, but I didn't "get" it on the one play--it's just too damned hard. But then I was playing like a puke and may have been influenced by my incompetance. But I played Brora a day later and loved the place.
So, most of my favorite courses aren't great, and I suspect a lot of the greats would leave me unimpressed.
K