Bogey,
I'll say 'no' to your question. There are certainly courses that have mystery within their design and that is a fact. The mystery comes about if option for how to play the hole exist. The options exist if width is inherent in the design, greens are either big or wide, and these options are enhanced by firm turf. Add an element of blindness to the mix and, I believe, you could have full blown mystery.
And to go a step further add in odd lengths of holes. To use Dismal Doak as an example, the par 3 5th is a long par 3. Sometimes driver for me, maybe a 3 wood.... heck if the wind is up, maybe 3 iron. But what is ideal for me given wind conditions? I don't know yet.
Also, Dismal Doak 14. Odd length par 4. Fairway mound and green side mound. What's the best play for my game? not sure yet. Ive tried a few different ways to play it, haven't settled on what is best. Ditto for 15.
Heard a lot of mystery exists at Royal County Down, checking that out soon will report back.
However, id say that most courses don't have too much mystery... and that's a shame. I can think of many courses I've played where after one or two rounds, I've got the ideal way to play the holes figured out. No mystery.... just simply hit it there... rinse, repeat. But for me, when I find one of these courses that is of interest intellectually, as well as physically in terms of execution, that is ideal golf. Personally, I think we need to highlight those courses and talk about them.