For most uses, the cloud wins in terms of quality and convenience. Local models make sense if privacy is paramount, you want to experiment without usage costs, or work offline, but you need a computer with a good GPU and are willing to accept somewhat less powerful models. I explain this in more detail in one of my blog posts.