Since your monthly usage is rather high, a CNG car will be much more economical than a petrol car. As you've rightly mentioned, the only cars available with a CNG + automatic combination are Tiago and Tigor. However, you haven't mentioned your budget, hence we're not sure how much you're comfortable spending.
That said, a CNG SUV that you could consider is the Maruti Brezza - its light clutch and smooth gearbox will ease your commute to a great extent. If budget isn't a constraint, you could also consider a diesel-automatic option like a Kia Sonet or a Mahindra XUV3XO.

