The Long Beach County courses are truly exceptional in what they offer to all golfers ("average" or otherwise) at a fair price. In order, Big Rec, Eldo and Skylinks are all a ton of fun and collectively representative of the bedrock/'heartbeat" of what makes "golf" great! Nearby Los Verdes Golf Course is probably better than the LBC courses -- be sure to tee off early!!
In my own (limited) experience the only real "municipal" option that trumps the LBC and LV courses is the New York State parks & rec system, of which the crown jewel is obviously the Bethpage State Park courses. As a close friend is wont to say...."oh my"...
In addition, the New York City courses like Vannie, Pelham/Split Rock, Dyker, Clearview & La Tourette can really be terrific if you hit them on the right day & time.
Lastly, from a personal perspective, I'd mention Harding Park where I've had wonderful experiences and made lasting friends...