Probably not quantitative enough for your needs, but CS3 runs well for me on my 1st gen 1.83 core duo macbook. I presume it would be just fine on newer ones to. My understanding is CS3 isn't hampered much by the macbook's lack of dedicated video.
I've been running Flash, Photoshop, Dreamweaver and Fireworks CS3 on my 2.2ghz Macbook for the last couple of days, they all ran fine. I stuck 4GB in yesterday and now they zip along