Hi @Wilhelm Nothnagel
As someone who lives in SF, is an out of state RE investor, and has two kids in SFUSD public schools, here are a couple of thoughts from my perspective:
1) If you choose to live in SF, you can find a good public school, especially an elementary school, if you don't just look for the "top-rated" schools but get out, go on school tours, and talk to parents who send their children to those schools. I cannot more highly recommend connecting with Parents for Public Schools, no matter what side of the bay you live on. Of course, prices in the city are insane--families are looking at areas such as Mission Terrace, Outer Richmond/sunset, Glen Park areas to live.
2) Out of state investing is not as scary as it sounds--go visit a market or two, connect with people from those markets on BP, and you'll find out that there's not a lot of barriers to investing out of state.
3) Buying a multi-unit in the E.Bay, living in a unit, and renting the others can be a great investment. But, you have to think of it as the place where you live first. Buying a multi-unit that "works" as an investment may well put you out of areas where you'd want your family to live. Finding a multi-unit around Lake Merritt, a fine area, that works from an investment standpoint, is going to be pretty challenging.
4) Make sure to attend a SF RE meetup. Great people, and you'll be able to learn so much by connecting with others in the area. @J. Martin is king--do contact him!
Best of luck and don't hesitate to give me a shout.
Steven