I'm more concerned with ethical sourcing than the country in which a thing was produced. I don't hold it against a worker in another country for wanting to support him/herself and family, and if his/her product is top knotch at a good price, I'm just as willing to purchase it. But if I know that the person who made that product is probably a slave, or getting paid less than a livable wage, while the seller gets rich, I'm not on board. That said, most of the "more affordable" foreign products tend to rely on super cheap (slave or sub-par pay) labor. Obviously, shipping stuff from Malaysia when you paid the workers there a livable wage is much less affordable than when you had a bunch of 8-year-olds work for $0.03/hour. So by the time you account for ethics, a lot of stuff made in the USA ends up back in the discussion for "most affordable." Electronics and cars are a major exception, as the Japanese have simply found ways to be more efficient (although as noted above, a lot of "Japanese" products are manufactured on US soul). Also, stuff like Coffee, which can't be efficiently grown in the US outside of Hawai'i, is almost always going to be more affordable from non-US sources.
I do prefer local over big box or online retailer, but that's more because it's easier to figure out whether a local business is treating its workers fairly, whereas an Amazon or a Wal Mart can much more easily mask its labor practices.