Now, I'm a humble guy, not known for making his opinions public...
You're welcome. Now, on to my opinion.
Augusta National-No. No access for the public to play, only one course, hosts a major championship every year, no connection to the origin of golf in its country, no connection to a great architectural figure (as St. Andrews had with OTM and DR.)
Bandon Dunes-No. Only due to the timing. It has everything else in spaces, and holds in my op the title of "Home of the Rebirth of American Golf."
Bethpage-No. The course complex is fascinating. There are few weak holes among the 90. I expected the Yellow, Blue and Green to have some, but they don't. Solid golf from 1st tee to 90th green. No real interest in the surrounding towns for golf. The denizens of the courses love their golf, don't get me wrong, but the fever/flavor does not extend into Farmingdale, Old Bethpage and beyond.
Myrtle Beach-No. Tempting, but no. It's a vacation destination first and a golfing destination second. I know that sound odd at first blush, but it's true. MB is also way too spread out to have any intimacy. What I think is cool about MB is the massive distance between the most northern and southern courses under the umbrella. No other place can make that claim. MB deserves its own special niche, just as Bandon has one.
Pinehurst-Yes. It's the closest thing we have to a St. Andrews. There can be no replica and we'd be fools to expect one. Scotland is a smaller and different country from this beast we call the USA. Pinehurst has the resort itself (8 courses, soon to be 9) and a great number more that surround. It has the village (noted by others) that loves its golf. It has the figures of James Tufts and Donald Ross, irremovable from golfing histories. It has the putting course at the resort. I'm told it even allows folks to walk the #2 course (you'll have to confirm) as long as they stay to the pathways. There are, however, no picnics nor dogs along the fairways.
FULL DISCLOSURE: I come by these opinions thanks to research I did for an upcoming web and print article. You may PM me for details on it, should you have interest.