Best LGA775 socket CPU?

Solution
That would be the QX9770 if you can find one and your motherboard can handle that.

Modern i5 have ~50% better IPC on top of ~20% higher base clock. If you have modern games in mind, even the best Core2 might still not quite cut it.