The choice of diesel, petrol or electric really comes down to your requirements and preferences. If your daily running is very high and you have access to charging at your home or place of work then an EV makes sense, if not relying solely on public charges isn’t really feasible. A diesel makes sense if you drive a lot and long distance too, this helps with lower fuel bills and saves you from stops to charge.
In terms of driving pleasure they all differ too. In general, an EV delivers a very strong acceleration which is fun but it is very linear and thus detracts from driving character. the torquey nature of a diesel delivers a effortless drive while a petrol – that is powerful – will deliver quick acceleration.
Since you are an enthusiast we would rule out the Tata Sierra DCT as it is paired to the naturally aspirated petrol engine which is down on power and delivers an very underwhelming performance. We would recommend the turbo direct injection petrol instead which is paired with an Aisin sourced 6-speed torque convertor auto and delivers much better on the performance front.