I loathe Pete Dye courses. Playing a Dye course vs say a Ross or Tillinghast or MacKenzie is like the difference between baking and cooking. The former requires precision and steadfast adherance to the recipe while the latters allow for riffing and creativity. I've played a half dozen and really didn't "enjoy" any of them, other than playing the final four holes at TPC Highlands and the 17th at Sawgrass. Mystic Rock at Nemacolin here in PA is just a pain.
When I lived in Quincy, I used to play Presidents after work regularly. Place was built on a landfill and had virtually no flat lies, nor did there really seem to be a "design" to it. But it was golf. Played Ponky in Clinton MA a few times, an old Ross design that fell into serious disrepair, but you could still see the beauty in it. Those courses and others in the Metro parks system cost like $20 back then and honestly, I was as happy at those places as playing the $75 daily fee places down the South Shore.
After playing more than 200 courses in 20+ states and 5 countries, I have some favorites, but they're often not top 100 courses, of which I've been fortunate to play a few due to a past job that valued client golf. Probably the one I recall most fondly was
Ko'olau in Oahu. It was nominally target golf played in a Jurassic Park setting. If you weren't in the fairway, you didn't find your ball. So many streams to cross at the outer range of your long irons you had to lay up constantly. At the time I played it in 2001, the slope rating was 157, highest in the country. My playing partners hated the place. But IMO, there's no other course like it in the US due to the setting, which at times seemed prehistorical jungle.