Tommy,
Regarding an affordable course that maybe few have heard of, perhaps the best I have seen in recent years is Wilmington Municipal. It is an excellent piece of land from both a soil and topography perspective.
Then, too, I think it is a course that works well for a variety of skill levels.
It has a great muni feel to it complete with a club house that feels like it is 80-100 years old and not the least bit pretentious.
Honestly, for probably 95% of golfers, Wilmington Municipal is a better course than even Bethpage Black.