> Picasa comes close but is useless when it comes to intelligently syncing a canonical "cloud" copy of each photo to a variety of devices linked to the account.

This might just be my device experience, but with automatic upload on, this is a non-issue for me; pictures taken on an Android device or uploaded to Picasa are available everywhere my Google account is.