Do I really need the extra cooling performance for the Quad core even if I don't intend to overclock?
It really depends.
If you want your cpu to last long, better cooling is required. Perhaps if you leave it on 24/7, you might want to invest in a better cooler.
However, the Intel stock cooling is good enough for everyday use.