Is France a good country to live if you are a nerd and want to have a "nerd family"?
A family of people that like studying, going to museums, etc.
Are you fucking crazy? Have you been living under a rock? Are you reading the news? No France isn't a good place to go.
To answer the question about being a "nerd", I would honestly say that in the current climate any Western country is pretty much hostile to them. If you want to be a nerd and thrive in doing so, and not be looked down upon, I suggest you move to China. Alternatively, Switzerland and Austria aren't bad choices for cultural pursuits, but they are in the process of being invaded by kebab, so I wouldn't recommend it.
Why would you want to come here ?
Spain isn't good enough for you ?