It does work.
I have taken a screen shot of the button in Aperture 3 and attached it her.
I select a picture and click the photo stream button and it adds that photo to my stream. In the screen grab I have attached you can see on the left the sync thing happening.
I don't have the latest version of iPhoto so don't know if that works.