It's possible the problem with the E8500 was caused by lack of power. The dell you mentioned comes with a 375W power supply. However, that doesn't really make sense since it has enough power for your current processor. Then again the power supply could be providing less than that now that it is 3 years old.
The 410 can only use C2D from the Conroe/Allendale family and Kentsfield Quads, not being able to get a Wolfdale to boot has nothing to do with the power supply.
I would suggest saving your money and buying new....Your upgrade options are going to be pretty limited for that vintage as Enzo said. The money your going to spend would go a long way towards a new low cost machine that will in all likelihood outperform the older machine and provide a fresh upgrade path in the future.
That's a quad core server processor. It would be a large upgrade but not worth the price since you are not running a multi-socket server. Upgrade your motherboard and cpu in your current computer to something more modern for less than that.
Anandtech had 2 q6600 cpus in their for sale forum for $130 or less. Make an offer; you might get one for close to $100. Lots of folks need cash this time of year.
I tend to avoid used computer parts. No warranty, no knowing how they were kept/treated/overclocked and the price usually isn't amazing compared to new stuff. Just my 2 cents though.