Notable fabs in Dresden: Globalfoundries, Infineon, Bosch (recently opened), X-Fab, First Sensor, Plastic Logic (now defunct). May be noteworthy that some of these fabs are among the semi fabs with the highest degree of automotation world wide.
Add to this many bigger and smaller suppliers, universities, reasearch institutes and so on.
https://www.silicon-saxony.de/nc/en/members/sorted-by-alphab...
There are also plenty of Fabs in other parts of Germany: Infineon, Bosch, Nexperia, TDK, Osram, TI, X-Fab, Vishay, Elmos and some I forgot probably.
There are also many design companies. Especially noteworthy is probably Apples modem team that keep growing and growing...
CERN certainly stimulates some semi research, but it is rather specialized.
Also, CERN heavily promotes open source software development, among other things by getting students super excited (high school trip to a super collider) and by raising research funding for PhDs to work on said software.
My guess would be this is more about diversifying. I think it makes a lot of sense to have factories in the US, Europe and Asia, especially given China's stance on Taiwan.
If you're fabricating things at 30nm, a strong gust of wind against the side wall of your factory might be enough to waste some wafers. If I remember correctly, they have a rubber shell to protect against it...
Also, there has been a growing amount of research activity into chip design in Germany lately, driven in no small part by CERN's needs.
For example https://ohwr.org/project/white-rabbit/wikis/home used by the Control and Timing System at CERN and GSI