If Photoshop is important to you and you haven't seen the video footage from the keynote from Photoshop World, I recommend
taking a look. The first part of the video is focused on the consumer end of Adobe's software, but they begin demonstrating a bunch of CS4 stuff at 12:00 (twelve minutes into the video).
To follow up, John Nack has posted
an important caveat to what you see in this video, which might lead on to think that CS4's 3D features are a tangent.
More will be presented on 9/23. If you wanna be a real fanboy, you can even
sign up to watch a live webcast on the 23rd.