I'm sure that CS6 will have some extra tools that will be really good & useful over previous versions, but I saw this video a few months back and though WOW...
But then to only read weeks after it was posted that Adobe admitted that they had fudged it by getting a good shot and making it blurry then deblurring it using this tool...
I'm sure that it will work to a certain degree, but maybe not as good as many may like or hope to what Adobe's claims it can do...
Just like the content aware tool that Adobe almost made you think that it would remove anything in a photo to replace it with what was originally behind.
Although I do use it a lot, and it works to a very limited degree, but in reality it's not as good as doesn't do what Adobe claimed it would...
Just saying so peoples expectations don't get crushed when buying expensive software with claims of miraculous fixes and find it won't do what they want..!!!.
For me Photoshop is magic.
About the expectations; You can buy expensive software like photoshop but that's no guarantee you can fix every photo. I believe most of the time it's not the shortcoming of Photoshop but the ignorance of the user. You have to spent hundreds of hours and more on Photoshop to understand just a little bit of this program.
The content aware tool, you mentioned, can not remove every thing but in my opinion this is one of the "magic" examples of PS 5. Even the most uninitiated person can use it if the situation is not to difficult
Example (Photo just out of the camera)
A quick selection with the " lasso " tool.
Then click " Edit " -" Fill", "Select" -"Deselect" and "voila" . It took me 30 secunds
(Some after work has to be done) Isn't this magic ?