Argo with DNS only

Is Argo helpful in anyway when cloudflare is used only for DNS and proxy caching is disabled?

In that way you cant use Argo at all, as requests will go directly to your server and will never reach any Cloudflare datacentre.

Thank you. What is the difference between Development mode and DNS only?

These two are unrelated. Development mode simply disables caching for three hours.