Some of the 45W "e" series chips from the last bump have finally shown up at Newegg, but unfortunately are way overpriced.
With very few exceptions (maybe SC2 is one?), I think it's pretty clear that even a mid-grade CPU can handle just about anything most people care to do on their PCs, from office tasks, to rendering, and games. Beyond that, however long it takes, I think GPGPU is going to provide a HUGE performance boost in those markets that need it (not just research and other for-pay applications). The CPU will never be irrelevant, but +/- a few hundred MHz pretty much already is.
As stingy as i5 and i3 are, I am hoping that Bulldozer and/or Sandy Bridge can significantly improve performance/watt. I'm sure performance will be higher, but I'd like to see lower power use being the biggest contributor to the improvement.