Make sure you have iPhoto's Photo Stream preferences set as follows:
What happens when you drag photos from the Photo Stream window in iPhoto onto the Events icon in the left hand pane? That should import the photos into the library.
If it doesn't thenTry the following:
1 - delete the iPhoto preference file, com.apple.iPhoto.plist, that resides in your
User/Home/Library/ Preferences folder.
2 - delete iPhoto's cache file, Cache.db, that is located in your
User/Home/Library/Caches/com.apple.iPhoto folder (Snow Leopard and Earlier).
or with Lion and Mt. Lion from the User/Library/Containers/com.apple.iPhoto/
Data/Library/Caches/com.apple.iPhoto folder
3 - launch iPhoto, reset its various preferences and try again.
NOTE 1: If you're moved your library from its default location in your Home/Pictures folder you will have to point iPhoto to its new location when you next open iPhoto by holding down the Option key when launching iPhoto. You'll also have to reset the iPhoto's various preferences.
NOTE 2: In Lion and Mountain Lion the Library folder is now invisible. To make it permanently visible enter the following in the Terminal application window: chflags nohidden ~/Library and hit the Enter button - 10.7: Un-hide the User Library folder.
OT