Its a good question, and it depends on the car and the mileage. So you can have garage queens with no mileage where all the fluids have evaporated and the rubber and automotive connective tissue has atrophied and you can have everyday motorway family hacks which have had all the usuals and also fuel pumps and suspension parts replaced which are fine. There is no simple answer. However, I have had a high mileage 730D literally bork its engine after I sold it and a high mileage 911 (996) also literally bork its engine after I sold it. So notwithstanding the loving mechanical care I lavished on both these cars they inflicted a €10k+ bill on their subsequent owners although after me they might have needed on the face of it to only unkerb an alloy and give it a wash.
So I tend to only ever now look at moderate mileage cars with a totally full and anal service history in any category. I trust myself to maintain cars, I do not trust previous owners. That's it.