I'll always be fond of Hartford Golf Club, having caddied there a bit.
I really enjoyed CC of Mobile and Pensacola CC when I played them two Mays ago.
Ft. Myers Country Club, in a city of about 90,000, is public. Are there any public courses whose namesake city is 100k+ population, with no private club with the name in it (e.g. Charleston Muni doesn't count because of the existence of CC of Charleston)?
I like the simple approach of simply naming a golf course after the town/city/county where it's located. Frou-frou golf course names are almost never an improvement over simplicity.