Looks like you're in luck. There is a worthy upgrade. A lot of people have asked about the same situation as you. Some are even talking about the exact same computer model.
The fastest CPU you can get, according to this chart, is the Core 2 Duo E4700:
http://www.cpu-upgrade.com/mb-Intel_(chipsets)/946PL_Express.html
A CPU's performance is based on a lot more than the cache size and clock speed, so some of the other CPUs like the Pentium 4's may look faster, but they're not. Just know that the list of Core 2 Duos present are the fastest group of CPUs compatible. I wouldn't buy anything but the fastest Core 2 Duo, the E4700. A quick search yields a market with various prices; from the original $200 price to $70 for four of them. It's a CPU, so it's very hard to make a counterfeit one that works, but be careful about who you buy one from.
Yes, there are faster Core 2 Duos, but your motherboard's 800 MHz front side bus is limiting your options. I believe that the fastest models under the Core 2 moniker used 1066 MHz or 1333 MHz FSBs. Don't plug in those models.
How fast is this CPU compared to your current Pentium D 925? Other threads say significantly:
http://www.tomshardware.com/forum/258945-28-pentium-core-e4700
It possesses the newest architecture there. Compared to your Pentium D, it uses substantially less power and consequently runs cooler.
If you're talking specs, they look almost the same, but the 2 Duo has much better scores on benchmarks:
http://cpuboss.com/cpus/Intel-Pentium-D-925-vs-Intel-Core2-Duo-E4700
I don't know how much the thing will bottleneck the 750 Ti (looks like it still will, sorry), but it should be MUCH less than your Pentium. It's something you have to risk and try out. Perhaps you should try overclocking the CPU? Good luck!