So I’ve just confirmed that my MacBook exudes similar whining problems as the MacBook Pro. The whine’s pitch varies with CPU usage, such as scrolling or dragging windows.
Solution Hack: Turn off the second core using the Processor System Preference panel:
Now I just have the clickity-clack sound of my vintage Apple Extended II keyboard (oh, and only one core)

I heard there's not much of a noticable every-day-use difference with the single core and the dual? Any truth behind that?
Probably not, probably more of a placebo: it just sucks knowing you're only using half of your power.