It was for a compiler position at Borland. I ended up working remotely for the next 6 years or so, first for a year as a contractor at a 6 figure Euro rate, then later as a salaried employee after I moved to London. They flew me over two to four times a year to keep up to date with the team. I collectively lived over 6 months in Scotts Valley, albeit in hotels. All this wasn't cheap.
You're generalizing from a stereotype you've seen. But don't think it represents all situations. The mentality you've got is the same one at work with racism and sexism. It's reductive and will mislead you.
There's a certain amount of tech talent at any given technical ability level available worldwide, and only a fraction of it is in the US. The opportunities to leverage tech talent are, however, larger in northern CA than most other places. And some things can only be implemented by people with the right level of ability. When you artificially limit the supply of qualified labour, all you can do is shuffle your existing resources - paying more won't increase the supply quickly enough. Limiting supply of able labour will reduce the speed of innovation and economic growth - including for locals.
Maybe these "body shops" are a problem. I don't know for sure - I don't have enough information. The way they are talked about, it doesn't sound like the quality of people brought in is terribly high, so it seems to me you don't have much to worry about re competition, unless you're not very capable. On the other hand, it sounds like it could be upskilling India as these people get rotated out, which to my mind is a good thing - beggar-thy-neighbour policies don't pay off in the long run, and besides are morally questionable when the disparity in wealth is very large.