I wonder if we could push this to 3 or 4 cores even? That'd be sick.
Well, 3 cores is not likely because it's easier, as far as I know, to do powers of 2 (that's why there are 2-way, 4-way, 8-way and 16-way and beyond systems or whatever).
4 Cores is still very, very far away still. As P4Man said, mainstream solutions won't come from 90nm with quad cores; that's physically very, very inconvenient. Actually, dual cores starts being a truly great idea from 65nm; Montecito, for instance, is a 65nm part. As is Jonah; AMD will also introduce dual core Opterons, but at 90nm - they will probably be expensive to manufacture... But dual-core is quite possible, even on 90nm; quad is not.
And there's always the holy grail of multicore: the 16-cored Itanium/Tukwila (former Tanglewood) processor for 2006/2007 or whatever.
God knows if this will materialize; if it does, you could have a quad-processor Itanium platform with 64 processors in a single machine. If scaling and interprocessor communication is performed seamlessly, this should be quite good. Of course, this is just for the server/ultra-high-end segment... And even if you consider the cheaper multicore alternatives - Opteron and Xeon, and possibly A64... well, most of us won't be using a dual-core processor for quite a while.
<i><font color=red>You never change the existing reality by fighting it. Instead, create a new model that makes the old one obsolete</font color=red> - Buckminster Fuller </i>