However, I think many people struggle to understand CSS and it's uses past simply changing text colour and making boxes.
It's a very good representation of what is possible given the skill/time to do so.
hehe I think you're both right.
That post in particular was a contest to see what people can do with the code in an experimental way. Not a guide on how to use CSS3 correctly. If there were no experiments in the world, we'd learn very little.
There are certain things - no matter how pretty a graph Illustrator could make, it can't make it read in data dynamically, animate the transitions between data sets, and output it to a web page all without you doing anything after set-up.
I think that as longs people take CSS3 in context and use it mainly for progressive enhancement, then the world will be a shiny, happy place