It's a legitimate complaint that syadmin'ing all these services is a lot of work, but I think that's actually an argument for working to make deployment of services such as MediaGoblin easier. Right now deploying web applications is hard... if we could get things at least to the point of deploying and maintaining systems are "as easy" (note the quotes) as "apt-get install" and "apt-get upgrade" then we'd be in a much better state. But there's a lot of work happening right now towards abstracting deployment; I think if we can turn some of that effort towards generalizing deployment recipies for everyone (not just people running big clusters of servers) we could make big improvement here. Projects like JuJu and OpenShift are probably the right directions, but admittedly I haven't had enough time to spend playing with them.