> there are very important things the CEQA does to improve our environmental conditions

Which fits with OP’s assertion that it does “more harm than good.” (Fortunately, restricting the private right of action would curtail a lot of the harm. On the national level I’m pretty much at the point of wanting NEPA repealed.)