There have been PCI FPGA boards available for a long time that can access main memory, I had them in my desktop machines nearly 20 years ago.
I don't think it would happen in a general purpose chip but I could see it happening in a smaller one like the exploits christopher Domas demonstrated against some embedded X86 cores.
Never heard of putting it into the socket, would be a real pain to attach JTAG to program/debug your design...