To be honest, you will not get good temps with a quad core and air cooling. The temps will be mediocre at the best. Just my 0.02. If you want air cooling, Tuniq Tower.
Sure fans and stuff like nice, but imagine how expensive and sophisticated liquid cooling looks! Don't know why you would even need to oc that cpu, it's fast enough on stock for everything
It will be really fast, but you won't see any performance difference over a normal Core 2 Duo when running single or double-threaded applications, so quad-core is overkill for the mainstream user. He should be fine with the Zalman cooler if he's not OC'ing though.