In San Francisco, the Sunset and Richmond districts might suit you. They're (relatively) affordable, popular with middle-class families, and a nice blend of residential and commercial.