Well I'm pretty comfortable using servers. In fact I've never used web hosting before. I'm dealing with lots of cloud and dedicated servers in my daily life.If you need to ask you are better off using regular hosting. Setting up your own fast/stable and secure vps has a steep learning curve.
But for some stuff like running a simple hobbyist XenForo forum, I would prefer a peace of mind. I created this thread to have an overall idea of how people are running their forums.
I guess I'll go with XenForo's Cloud solution once it's released. I signed up for Beta for a while ago but still haven't received anything.