Instead of upgrading the notebook, you may want to consider switching to a solid-state drive. In terms of real-world performance boost, an SSD simply can't be beat. It's like upgrading to 60 or 120GB of RAM for <$300.
I am not convinced that most MacBook users are CPU constrained. SSD FTW!