IMO, Fremont's main desirability is affordability & schools. I met with quite a few young family (with kids 2-4 yrs), they are all interested in moving to Fremont (currently living in Hayward, San Jose, Santa Clara) because of schools & safe city. Good mix of Asian groceries, Traders' Joe, Wholefood (the only Wholefood in 880 corrider as far as I know).
On top of that, Fremont is versatile if you switch jobs. One of my friends said, Fremont is not near to anything, but it is not far from anything. Either your work is in SF, San Mateo, Mountain View, San Jose, your commute is doable (not great, but doable).
I think Fremont won some best place to raise family and most startup coming or something like that in past couple of years. I used to live in Fremont (and commute to City & later commute to MountainView) and still own a place there, so there might be my bias there, but just my opinion.