In American English, Madrid Spain is like Mu-drid. Madrid Alabama is like Mad 'rd. It is like being Mad or angry. I didn't see anyone pronouncing it like a local. These are places with a thick annoying southern accent. So it is typically said in a very annoying way with the emphasis strongly in the wrong place.

With Lafayette it is as annoying as possible like Lu as in Luck, FAY as in FAke, at as in hat. All three are like separate word syllables they are so disconnected in a southern redneck American draw.