There is no inspector level override to allow projects.
CEQA overrides all this. Here's a person that spent five years in courts, because a neighbor didn't want a single family home to expand due to aesthetic concerns, that suddenly shifted to fake "environmental" concerns as soon as the city level obstruction failed.
https://twitter.com/tribtowerviews/status/162851785910113075...
The threat of years of lawsuit is enough to kill most projects, as that amount of uncertainty and risk will eliminate all financial backing for any but the very most motivated, such as those living in their own homes with tons of money to burn.
Discretionary approval of projects is definitely a corruption machine, as exposed recently in LA, and any politician that endorsed discretionary community review is almost certainly corrupt. However it's also the norm in California.
Even with that discretionary review, CEQA is still a powerful tool for stopping projects that improve the environment, due to the long decision timelines.