it depend on the craft smith's skill. everyone have access to Python but some is able to craft a robust app while others app is buggy and unusable.
TSMC consistently have the best yields and quality chips
Expertise and facility time are the limiting factors. Low volume purpose built SOCs will never be cheap (outside chiplet-based designs) because the ability to fill out a production line is critical to amortizing the immense startup cost of a design.
It is already possible to have completely custom chips built in lots of <100 on older manufacturing nodes. Runs cost low five figures to low millions of dollars. Some college courses involve having an entire chip made. Anyone can order one on 20-30 year old equipment. There is no demand and it will never get significantly cheaper aside from mass-produced chiplet ICs.
The vast majority of variety in product lines comes from who is ordering the chips, not the foundries where they are made. Adding more foundries will not introduce any more different chips, just chips that have subtly different performance or reliability, which is already a nightmare engineers deal with continuously.
China sells the cheapest chips, and companies only buy the cheapest chips. Making more foundries in the EU and Europe will not change that fact. China will have the huge majority of demand. If anything, a reduction in demand will give more power to counterfeiters and raise the floor price you have to pay to avoid them. It won't really impact prices at all (counterfeit chips are almost nonexistent for anything costing more than a couple cents) but it will make life significantly more irritating for people like me.