http://www.photoshopuser.com/cs3/videos.html - You should be able to check out those videos... showing off features and whatnot :)
http://www.russellbrown.com/tips_tech.html - He annoys me but he has some cool demonstrational type vids too in quicktime format.

CS3 beta totally kills me for my workflow in working with multiple files stored in multiple locations but I might be able to adjust - even if it means taking a step backwards to how I did stuff in 7 :(  
I've been messing around with PS since version 5 or so and I have to say that this CS3 has to be the most impressive for new features that I can use.  CS was possibly the worst for new features IMO - I never put CS to much use.  Half the time when I'm getting mad at PS I end up thinking they need to rewrite the code from the bottom up so it's not so damned slow or when the simplest things take way too many steps... I could go on and on... but CS3beta doesn't seem to be any slower than CS2 on my machine yet but I've only used it for maybe 30 minutes so far.  I use PS at home for fun and (hopefully more often in the near future) profit as well as at work... I'm not really the 'graphic designer' type though.  More into manipulation and fixing photographic things.

It IS a beta though and there are definitely some issues still... so keeping an eye on these forums at adobe isn't a bad idea.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid=72&amp;catid=626