You are thinking about yourself as a skilled technical person, not the general consumer of Apple products. The whole "it just works" marketing statement from Apple is key.
You and I will continue to use DropBox, Flickr, rsync, tar, scp, Aperture, svn, Eclipse, and jailbroken iPhones.
The other 95% of Apple's customers will relish the fact that all the sudden, for free, they can take a picture on their iPhone, show it to their friend on their iPad, and then show it to the entire family on their AppleTV without having to do anything but take the picture.
And you can bet that Apple learned their lessons with MobileMe.
Basically, Apple is betting the farm on providing a private back-end infrastructure that front ends all of their products. It is certainly a gamble and fraught with land-mines, but if they pull it off it will serve to take away additional market share from Google and the other big OS/Mobile companies.