All the models you have shortlisted have their highlights and weaknesses. The Maruti Suzuki Brezza is a well-rounded vehicle that excels in space and comfort. Maruti's service network is a huge plus in its own right. However, as you rightly identified, the Brezza is not exciting to drive. This Maruti Suzuki car's performance is fine in city driving conditions, and it will cruise comfortably on the highway. But the engine lacks punch in case that's important to you. 

If strong performance and good handling are requirements, the Skoda Kylaq and Mahindra XUV 3XO are the ones to be most interested in. Both models are good to drive, but fuel economy could be a concern in bumper-to-bumper city driving. 

We feel you will find a good balance in the Hyundai Venue 1.0 Turbo DCT. The engine is strong enough, and the gearshifts are also nice and quick. DCTs do tend to fumble at low speeds and aren't as smooth as torque converter autos. Although, it's not really an issue and surely not to the extent of avoiding the gearbox type altogether. 

Fuel economy should also be better than what you'd get with a torque converter.  The new Venue is also quite a wholesome package. The cabin is quite spacious, and the material quality is impressive. 

The Nissan Magnite is a good option for you. It has a spacious cabin and a comfortable rear seat that can accommodate three adults. 

Apart from a 1.0 NA petrol engine, the Magnite is also available with a punchy 1.0-litre turbo-petrol engine that can also be had with a CVT automatic. Meanwhile, the Skoda Kylaq's rear seat isn't as spacious for three adults.

The choice between an automatic and manual will really be down to your comfort levels. 

If you are not confident about driving a manual or have a lot of traffic to deal with, then an automatic would be better. In this case, pick the Maruti Suzuki Fronx AMT; the shifts will not be as smooth as a torque converter unit. But at least you won't have the hassle of changing gears yourself. 

If you can stretch your budget, opt for the 1.0 litre Turbo Fronx, which comes with a torque convertor automatic gearbox, or you can also opt for the Skoda Kylaq automatic, which also has a torque convertor and the lower variants would be a bit cheaper.   

You can consider the Skoda Kylaq. Most automatic cars in this price segment offer an automated manual transmission (AMT), which is not a very smooth shifter. 

The Kylaq, on the other hand, comes with a torque converter (TC), which is by far the smoothest gearbox around. 

The Kylaq's compact dimensions also make it perfect for the city, and it has enough space inside. Fuel efficiency will not be as high as that of a Maruti Suzuki Swift. However, since your running is low, this should not be too much of an issue. You will certainly enjoy the smoother shifting gearbox.

Since your driving is very little and almost all of it within the city, we would recommend the Skoda Kylaq automatic version. 

Most automatics in this segment come with an automated manual transmission (AMT), which are not smooth shifters. The Kylaq, on the other hand, comes with a torque converter (TC), which is the smoothest type of automatic transmission around. 

As for performance, the 1.0-litre turbo petrol is lively and strong enough, especially for the city. As for safety, it is well kitted out with safety features like standard 6 airbags, and it also secured a 5-star crash rating in the BNCAP tests. 

The Skoda Kylaq is one of the better compact SUVs in the market, so if you are inclined towards it is certainly worth buying. 

Being an SUV, the elevated seating position, which gives you good visibility of the road, is useful for first-time car buyers like yourself. We would advise you to opt for an automatic transmission because it will make your life behind the wheel a lot easier. 

The Kylaq’s 6-speed automatic is quite smooth and responsive, and paired to the 1.0 litre TSI engine, performance is effortless too. In terms of reliability, the Skoda doesn’t have the best reputation for service, but we don’t think that should be a deal breaker. 

With its 5-star crash rating, the Kylaq is very safe and known for its tough build.