Everything impressive sadly, don't want to derail the thread but here's the wiki article.

http://spore.wikia.com/wiki/Removed_features
and the original beta video
https://www.youtube.com/watch?v=T8dvMDFOFnA

If you played spore you will probably immediately notice that the released game is way more cartoony and orientated towards kids. EA basically decided that the game would do better if targeted towards a younger audience.