Jordan,
This one's easy for me...
Lincoln Park.
I did not care for the place initially, but I kept coming back again ... and again. The green fee being low helped
.
Not necessarily exciting, but just about always entertaining and challenging. It comes from not knowing where the drive could roll to on the fairway on several of the holes (4th a great example). It comes from taking advantage of the wind on certain holes and "going for it" (11th). It comes from the 17th tee. Plenty of other things as well (blindness for instance).
It never gets boring despite its poor shape. Humps, bumps, uneven lies, wind, fog, quirk, etc. I love it.
Found only on great courses? I'm not so sure, but I would think it's most certainly an element of great courses.