I went to Turnberry with low expectations, and I was delightfully surprised with what I found. If anything, it's underrated and should hold the Open more often than it does! I agree with Jason's classification of holes: the stretch of holes from 4-11 is possibly the best consecutive stretch of holes in Scotland, and while 18 isn't much of a finisher, 15-17 are superb.
(Funnily enough, Sean, I think Pebble Beach is very overrated, so the corollary you suggest doesn't universally apply...)
Cheers,
Darren