Building in a new development area when there are social housing units around?

It is about buying a house, it is already being built in a large new development area, several dozen are already completed and occupied. Directly around this area are many old dilapidated large social apartments/row houses, between the garden areas of the new buildings and the social apartments are only a few meters, mostly separated by tall trees. The view of my garden would therefore be largely obscured, and I can also put up a 1.80-meter fence, nevertheless, there are many non-Germans in the area to put it kindly. My goal is not necessarily to walk around alone at night but rather to mostly drive by car to surrounding towns, for shopping during the day the surroundings are enough for me. The house (semi-detached) being built is perfect in that sense, price as well. Would you dare to move there or would it be a no-go for you? On the other hand, I think since dozens of new houses are already lived in, it can't be that bad... I am torn back and forth...

Directly around this area are many old dilapidated large social housing units/terraced houses, only a few meters lie between the garden areas of the new buildings and the social housing,

Then buy quickly before this neighborhood becomes unaffordable due to semi-detached houses gentrifying it.
If necessary, gain respect with a gold chain AMG, Alda.

dilapidated large social housing/terraced houses,

How does that fit together? Terraced houses are old, therefore dilapidated?

My goal is not necessarily to walk alone at night but rather to mostly drive by car to nearby towns; for shopping during the day, the surroundings are enough for me.

So, you should definitely feel comfortable in your own neighborhood. You might not be able to sleep if the neighborhood seems suspicious to you?!

You already have doubts now, then it won't work even if it looks different in 10 or 20 years, a lot will happen until then. How about school, kindergarten, etc.? That would be more important to me

How do you feel on site? Like, if you actually walk around during the day? (If you’re being excessively skeptical right now, even as a pair?) Talking to neighbors? Older houses and apartments wouldn’t bother me per se. Feeling permanently uncomfortable as soon as I leave the house, though, is not an option. That would be a dealbreaker for me. So a “I can just drive 500m to the supermarket because it’s too dangerous to go on foot” – (which I’m freely reading into what you said) -> nope, if I have the choice, I wouldn’t move there. The question is whether that’s your first impression, but actually it’s not that bad, right, or if there’s something to it.

Just personally: we’re not moving to a “good” neighborhood but to one that is statistically poorer, with higher population turnover, higher unemployment rate, and a higher proportion of foreigners than the city average. But it’s not like it’s miles behind the rest. As far as I could tell, it’s not one known for gang crime or anything like that. (That would be a point that would probably make me uncomfortable). It’s not that densely populated either. The few neighbors I’ve talked to so far have all been nice. I also went to the supermarket on foot alone as a woman without worries. So far, I haven’t discovered any “I don’t hang around this corner too long” zones (at our last place, there were such spots I didn’t like going near. But that was more “that one corner” and not “the entire neighborhood”). So, so far, all good. But how you feel about it, you can probably only find out yourself.

Directly around this area, there are many old dilapidated large social housing/apartment blocks; only a few meters lie between the garden areas of the new buildings and the social housing, mostly separated by tall trees.

Even in Düsseldorf, where I work, sometimes only a street separates areas where there is a price difference of several thousand euros between condominiums. Slangily put, "trashy" vs. "posh." But you really have to look very closely at how the areas look. I can't give you a blanket answer; for that, you'd have to lower your address pants. But I can't imagine an enclave with 100 new houses, completely surrounded by trash.