I have 6GB in my MacPro and I'd say that's a solid amount for me. I've figured out how to run my system and not max that out, and as much as I'd love to buy another 4GB just because I have empty slots - I really don't have a need for it. Here is what I'll usually have open:
Mail, Adium, Safari w/several tabs, PS CS3 (settings set to use 3GB), Aperture with a (currently) 29,915 image Library (I'm cleaning it out right now), Coda (HTML Editor) CSS Edit (CSS Editor), MAMP to run my website projects, iTunes playing all the time. Doing all this I'll still have about 1GB free memory (including inactive).
Now, to get to my point, you mentioned that a C2D wouldn't have enough power to handle 8GB of work and I beg to differ. Rarely when doing what I'm doing do I ever tax my processors. Just because you're utilizing RAM doesn't mean you're making your CPU do anything difficult. A 17" C2D Macbook Pro w/8GB RAM would work just fine for me. But I could afford a MacPro and really liked the internal storage and 2+ Monitor capability etc. And I was done trying to manage a huge Library on an external drive with a Laptop.