Had the Audi Q3 – S line Plus 2.0 TDI Quattro 184 myself, had to change it early for an Auto. Swapped it for an BMW X1 2.0 D Sport D AWD 2 years ago. Love the car. Even more than the Audi. Not sure if it will be on the scheme in the 2nd quarter. If it is and it is affordable that would be my 1st choice.
The Kia Sportage has a good reputation, more importantly to you is how practical and comfortable is it. If it ticks the boxes I’m sure you will be happy with it.
2024 - KIA EV6 GT Line AWD
2019 - 2024 BMW X1 2.0d X Drive Sport Auto
2017 -2019 Audi Q3 2.0d Quattro Sport Line Plus
2005 - 2017 Honda CRV Exec 2.0d