I think the main thing to do is not to panic. You can read horror stories about all manner of vehicles and scare yourself off them, I did when I was looking at the TD4 auto and the ML270 auto

Buy the best you can afford, check and maintain/service it regularly and it should be good for many happy years