A 240d in many ways is my favorite car. Plus well suited to our low traffic density area. Especially the secondary roads.

At the same time in some driving enviroments it may lack too much for safe operation.

Some also seem to be too noisey at todays highway speeds compared to others. This can be bothersome.

As already mentioned. Any new to you example will usually benifit from doing service on it. You need or want every last horespowere that it is capable of producing.

Your pedal will be on the floor a fair percentage of the time in comparison to cars with far more power. Personally I feel the manual transmissions are both far more reliable and help you drive the car. As you definatly have to drive them I find. That may be part of their attraction.