I have jet skied there, I wouldn't dive there unless I was being paid.
We did some environmental testing there, years back; so too, at nearby Oakland Harbor, about three miles away; for Richmond, on the site of the WWII Kaiser Shipyards, somewhat farther off — and, halfway across the Bay Bridge, at Treasure Island, while it was still Navy, back in the 1990s.
It paid well; but it still wasn't worth the filth of that whole East Bay area -- just took forever to eliminate the stench from our suits -- even with the generous use of a harbor fire hose; and we often drove back with windows down, regardless of the temperature or time of year. The visibility was virtually nil and the harbor waters frequently reeked of hydrogen sulfide from the anaerobic mud — even visibly bubbled up in a few noxious spots. There was hazardous rebar and refuse everywhere from decades of the heaviest "dump-it-who-gives-a-crap?" industries; and the sediment had all the texture of a loose chocolate pudding.
One misplaced kick, underwater, and it became black as night. The creepiest thing that I ever found, was a female mannequin’s leg, from hip to foot.
From a related thread:
"While collecting sediment samples in Oakland Harbor . . . something there -- perhaps, some polar solvent, aside from usual the nasty harbor water -- affected the polycarbonate visor of my full face mask. It became softened, crazed, and required an expensive replacement; but I would rather it have damaged that poly visor of the mask, than my skin . . ."
It is not worth your time -- you really don't want to put the "hep" in hepatitis; also, they may no longer even allow diving around the Coast Guard site, post-9/11. We had to carry extensive permits when we were last there; and even then, the "coasties" were none too pleased . . .