It's alright, I rarely have to touch it, but I'm no Sysadmin. If I had ops/sysadmin guys to shove onto, I would have no qualms using it long into the future.
I would, ideally, like a hosted build server, and a hosted Octopus - I really like it. Not the biggest fan of team city, but it works, and it's the only thing I know well.
Yeah, that's why we wanted a cloud solution - none of us really have significant sysadmin expertise, nor the time to devote to tending more boxes than we absolutely must. Only having to maintain the actual build environment has been a win.
We've had a couple occasions where we ran out of disk space (though not since we increased the disk size and added a cleanup job), and a few times a build agent has randomly stopped responding and needed to be restarted, but nothing we couldn't easily diagnose and fix.