Hi and Welcome to FOG!
SWB 2.0 is a bit underpowered really.
Best bet is a 2.8 LWB or SWB. Averages about 28-32 mpg by all accounts. Torquey engine and reliable.
Later models from 98' on the 2.2 DTi is a good bet, available in SWB and LWB goes like a rocket and returns 30-40mpg.
Im on vq9 as well, same nickname as here

Best of luck.