Try
EscapeArtist Home Page: Living Overseas - International Real Estate, Overseas Jobs - Expatriate Resources - Overseas Retirement I think it's an expat site for Americans and they might be able to give you some good advice.
Bear in mind that property is more expensive in Europe ( a lot less land than in the US so it's at a premium).
In France I would recommend the South West ( Dordogne, Gascony that sort of place). Manufacturing wise you would be better off trying to find jobs in Toulouse ( big university and manufacturing city) , large-ish English speaking community and you could live in the country side on the outskirts, also Bordeaux ( for the same reasons). Unemployment is higher in France but Bordeaux and Toulouse are both quite wealthy cities. Public transport is excellent too.
Also try :
Bordeaux British Community ( Bordeaux British community)
Portal for Work Abroad, Study Abroad, Cultural Travel and Living Overseas.
www.frenchlinks.org (broken link)
They might be able to help.
I'm afraid I don't know enough about Spain to tell you anything about it though.
Hope that helps, all the nest and good luck for your move !