it depends on the programs you run. currently, most games do not support dual core CPU's. however future games will.
once they do, you will see a big performance gain from them.
and what you said:
2 cores for $330 verses one core for $250
if it were a dual CPU system instead of a dual core system, you'd be paying $500 (if, hypothetically, there were dual socket 939 motherboards)