> I've also heard of contracts that essentially prohibit side projects or moonlighting.

If your employer is sufficiently broad, the California Labor Code basically prohibits side projects or moonlighting:

https://leginfo.legislature.ca.gov/faces/codes_displaySectio...