As much as I hate to say it, the 240D isnt that great a car compared to what is out there.
If you compare cars by size/hp and fuel economy, the 240D is an overall loser...
yes, if you go by the numbers, the 240D sucks. I dont go buy numbers so I LOVE my 240D. If you dont love driving the thing (a W123) forget about it. 240D's are relatively easy to find with a stick though...
The 190D's smaller size has a LOT going for it. I assume that a VW TDI is out of your price range (otherwise, I'd get one too)
I would reconsider a vw diesel though.
Bads-
smaller
Front wheel drive
"refinement"
no auto trans

Plus
-35mpg no matter how hard you stomp it
-easier to park

The internet support for both vehicles is about the same. Lots of local VW boards along with vwvortex.com (good stuff in there, but you need to find it)

I'd seriously consider trading my 240D for a 80's vw diesel (of equal value). (if you dont miss the interior room). Parts cost and aftermarket/junkyard support are about equal.

Maybe I just want to swap an OM617 into my 240D, maybe then I'll be happy =)

To each his own
-John

__________________
2009 Kia Sedona
2009 Honda Odyssey EX-L
12006 Jetta Pumpe Duse
(insert Mercedes here)

Husband, Father, sometimes friend =)