I haven't seen much offshoring to Mexico or Poland lately. Brazil, Philippines and India still are the three biggest with Argentina becoming a new place that companies are investing in.
Some of the jobs are regional level. For example a lot of jobs are moving out of the major tech and corporate hubs California, Seattle, NYC and others. These tech and corporate jobs are now moving to Nashville, Austin, Phoenix, Salt Lake City, Tampa and other areas. The tech companies that are still in California are now going remote or staying remote and hiring people from low cost of living cities instead of hiring people in California. The cost to hire these remote workers is far less than it is to hire someone from California.
What is even more crazy is that Phoenix has gained more than just TSMC. Boeing and some other major manufacturers from California have now moved their operations to Phoenix. The Phoenix area is quickly becoming a major tech, corporate and manufacturing hub. In the west valley you have a lot of new data centers, manufacturers and tech jobs. In the north valley you have a lot of corporate, health care and tech manufacturing jobs. In the south valley there are a lot of manufacturing jobs. In the west valley it is a mixture of tech and corporate jobs. A lot of the facilities in the north and west valley are either new created in the last 3-5 years or are still under construction.
In this market if you are not willing to move to where the jobs are good luck and I hope you like a blue collar job because that is what you are going to have to take if you are not willing to move. There are some remote jobs but the competition is just insane. I have a friend who works in HR and whenever they post a job for remote work it automatically gets about 5000 plus applications while the in person roles get about 100-500 applicants and there is very little crossover between the two applicant pools.