1) Safety. This is mandatory. This would mean water quality that is healthy to dive in, so you don't risk getting sick. Cleared of unreasonably unsafe submerged objects, and protected from above water hazards like boat traffic. Fishing should be banned or segregated so you aren't swimming amidst baited hooks. Topside security. You don't want to spend your dive wondering if your car and/or it's contents will still be there when you surface.
2) Enjoyment. This would include good visibility (at least 10' for a lake, preferred at least 20'), something underwater to see besides rocks and mud, since it's a scuba park it should have easy entry and exit points.
3) Amenities. Topside conveniences to make the day relaxing rather than a challenge. There should be close parking, shaded tables, restrooms, somewhere to change (and a shower would be nice). Air fills and tank rentals on site, and perhaps a small dive shop and nearby store.
4) Cost. Proportional to quality, but no more than $25. At least for anything you would find in Texas (show me 100' depth and 100' viz and I might open the wallet a bit wider). And for cripes sake, stop charging for non-divers or at least just a few bucks. I want to be able to bring my wife and small kids with me so a day diving isn't a day away from the family.
IMO, most scuba parks seem to be run by owners who have little business sense and a poor attitude. CSSP is the best and even they are lacking in many areas.