Hi welshwizard, if it was the one litre it'll have been a Karoq. Weakest in the Kodiaq was a 1.4, 125 bhp. The one litre Karoq has either 110 or 115 bhp. Really needs the 1.5 150 bhp engine. I'm surprised your economy was bad.
(I've driven several engine variants over the past 6, 7 years, Octavia, Karoq and Kamiq, and while the performance with the lower spec engines is "average", the petrol consumption has always been good, with little difference manual or auto boxes. My 1.5 Karoq managed 37 mpg over 20k, with a few long distance tanksful/tankfuls? giving 47++ mpg.)
Now, my 2 litre petrol Audi A4 Avant, 190 bhp, gives over 36 mpg, even driven fast. It's also very comfortable over long distances, almost but not quite as good as my old 9-5.
Anway, back on topic, I hope Will gets his 9-5 back soon!