Side effects from over-doing it are basically mental slowness and a lack of motivation (even this will go away if you just stop for a while). If you start sucking at your job, your suckiness should show up on your performance review and HR should handle you accordingly. Maybe you get fired. This is how an alcoholic would be handled, anyway.
There is way too much fear and over-analysis surrounding this topic. The tools to manage it are already here. Marijuana is already here, and will continue on just fine regardless of whether it is legal or not. Overachievers like Michael Phelps and Barack Obama will smoke marijuana and go on to do great things, just as they always have.
Just legalize it already so we can finally benefit from California's number one cash crop, out in the open, rather than letting the majority of the profits go into the pockets of people who very often do pose a credible threat to society and require insane amounts of tax dollars to manage.