I'm sure PS CS5 will be great. Illustrator and Dreamweaver CS4 are massive failures. Unless Adobe strips out features and dramatically improves performance... There is no hope. As of CS4 I have started migrating to other applications for my development needs.
I'm considering going back to CS2 or CS3 if CS 5 doesn't do something magical.