My wife has a 2000 TD4 Diesel automatic with 130000 miles on it. I bought it Oct last year. Few problems:
1 Had to replace 2 electric window motors (common fault), the wire breaks in them not actually the motor themselves. You can buy the wire on ebay for £20.
2. Had to put a camshaft pulley cost £150.
I find the car great and wife wouldn’t swap for a car now. These problems you will have with any car at this age and mileage. You would have to get the diesel TD4. This is the BMW engine and gives no trouble, I had a rover 75 and had the same engine.
There is value to be had in these cars as they have a bad reputation and you will have to allow for some maintenance on them. Lot of people have problems with the petrol car and give the whole range a bad name.
I get all my labour for free, my brother in a mechanic.