A manual 240D will do everything you want, but will be very slow, especially pulling a trailer. They made a 240D, but it was never officially imported to the U.S. A few may have made it over. There are factory manual 300D's, but they are all Euro non-turbos. They have around 80 horsepower vice the 240D's 62-67. As stated above, it's not all that difficult to convert an automatic car to manual, but the automatics really aren't bad.

As for mileage, my 300D gets better mileage than my 240D. I think it's because of the better brake specific fuel consumption of the turbo engine along with the taller rear end (3.07 instead of 3.69). Also, I'm not sure what your idea of "good mileage" is. My cars have gotten everything from 17 (short trips on cold starts in very cold weather and city traffic) to almost 30 (highway, moderate speeds and temperatures). These cars only get 40+ mpg in used car ads.

__________________
Whoever said there's nothing more expensive than a cheap Mercedes never had a cheap Jaguar.

83 300D Turbo with manual conversion, early W126 vented front rotors and H4 headlights 401,xxx miles
08 Suzuki GSX-R600 M4 Slip-on 26,xxx miles
88 Jaguar XJS V12 94,xxx miles. Work in progress.
99 Mazda Miata 183,xxx miles.