You're thinking of LGA 775
only 20 pins off.
Anyway, I searched up a bit, and the Dell Dimension 5100's 945G chipset based motherboard does not support Core 2 Duo processors unfortunately. However, they do support Pentium D processors, which you may like to have a look at.
For games, you'd see a bigger improvement improving the graphics card, CPU too I suppose.