The author mentions but doesn't address the Picasa problem, which incidentally is the one I care most about. What do I do when all the useful software is cloud

The author mentions but doesn't address the Picasa problem, which incidentally is the one I care most about. What do I do when all the useful software is cloud based and requires me to store my data with the service provider in order to use it? Self hosting is not a solution.