It's not just the Bay Area. The restrictions and FAA guidelines are written in a way that prohibits almost all recreational flying in urban areas. I don't think I've seen a single widely-shared drone video that wasn't afoul of the law.