Skoda Kylaq Prestige+ MT

There are a couple of options that you can consider. We've listed the highlights for each.

1) Skoda Kylaq: Punchy engine, fun handling. Rear seat space is tight, though

2) Mahindra XUV 3XO petrol: Strong engine, good ride comfort. Boot space is limited

3) Maruti Suzuki Fronx Turbo/ Toyota Taisor Turbo: Strong engine. Reliability and hassle-free ownership experience 

4) Citroen C3: Strong engine. Feels a bit basic, and the service network isn't very large.

All modern cars today, if maintained well, are engineered to last 10 years or more. Over that period, you should budget for both scheduled services and some wear-and-tear replacements. Given your usage pattern with limited annual running and long idle periods, the way the powertrain behaves when used sparingly becomes more important. Since most of your trips are short and local in Kasaragod, outright performance is less critical than smooth and reliable operation.

Between the Skoda Kylaq Prestige Plus (1.0 TSI with 6-speed torque converter) and the Hyundai Venue HX8 (1.0 Turbo with 7-speed DCT), both should serve you well if maintained properly. However, purely from a mechanical durability standpoint, a conventional torque converter automatic, like the one in the Kylaq, is generally more tolerant of stop-go driving and long-term ownership than a dual-clutch transmission (DCT).

DCTs offer quicker shifts and better efficiency, but they are more complex and can be sensitive to heat and crawling traffic. This is something your sister is likely to encounter in town driving. Over a 10-year horizon, especially with intermittent usage and possible long idle periods, the simpler torque converter setup is typically the safer bet.

That said, both cars use small turbo-petrol engines. Modern turbo engines are reliable, but they are inherently more complex than naturally aspirated (NA) engines. It is due to additional components like the turbocharger and intercooler. If absolute long-term peace of mind is your priority, you could also consider the Maruti Suzuki Brezza, which comes with a 1.5-litre naturally aspirated petrol engine paired to a 6-speed torque converter. An NA engine is mechanically simpler and, in theory, better suited to low annual running and long ownership.

As for the Tata Punch EV, it is an excellent value for money as an EV. However, in your specific case, it may not make complete sense. Your annual usage appears limited, so you won’t significantly benefit from the lower running costs of an EV. 

Additionally, the Punch EV is compact with a smaller boot, which may restrict practicality during family visits. Long idle periods are also not ideal for EVs unless the battery state of charge is managed carefully.

If you like the Skoda Kylaq AT, go ahead. It’s a very good car to drive, feels solid, and is the most engaging of the three. Low running will naturally minimise wear and tear, and modern turbo-petrol engines are perfectly fine for city use as long as they’re maintained properly. Don’t overthink the naturally aspirated vs turbo debate purely from a reliability standpoint - upkeep matters more.
The Honda Elevate CVT and Maruti Suzuki Grand Vitara are bigger and more spacious, and both are sensible, comfortable choices. The Elevate’s naturally aspirated engine is smooth and predictable, and the Grand Vitara scores well on efficiency. However, neither feels as enjoyable or as tight to drive as the Kylaq.
Given your priorities - long-term ownership, decent safety, good NVH and low running - the Kylaq fits well if driving feel matters to you. If space and a more relaxed nature matter more, then the Elevate would be the calmer choice. But purely from the heart-and-head balance, the Kylaq is the one we would pick.

You will have to stretch your budget significantly to purchase the Tata Sierra automatic. For around Rs 12 lakhs on-road, what you can shortlist instead are the Mahindra XUV 3XO MX3 Turbo-AT and Skoda Kylaq Signature AT, both of which are safe, spacious, comfortable, and also get a sunroof. 

The Maruti Brezza is likely to get an update in the coming weeks. Since you are not in a hurry, you could wait and see what it has to offer wait for, before going ahead with the purchase.

Between the Kia Sonet and the Skoda Kylaq, the Kylaq is the better choice for you, especially if driving enjoyment and long-distance comfort matter. It is the nicer car to drive, has a more comfortable ride on highways and feels excellent value for money. 

The Sonet is still a good all-round compact SUV, but it is not as engaging to drive as the Skoda Kylaq, particularly in terms of handling. Another factor to keep in mind is that the Sonet is expected to be replaced in about a year. It means there is a chance it could start feeling dated sooner than you would like. The rear seat on the Sonet is also on the tighter side.

Since you have mentioned that there will be occasions when five people travel together with luggage. It is important to note that both the Kylaq and the Kia Sonet are relatively narrow cars and are most comfortable as four-seaters on long trips. If proper five-seat comfort is a priority, the Mahindra XUV 3XO is a strong alternative. Its wider body allows it to accommodate five adults in better comfort. It is also a fun car to drive thanks to its punchy 1.2 turbo petrol engine and well-sorted suspension.