Which car do I buy?

Hello dear people. I am currently looking for a car for everyday life. Especially for my work journey of 2 times daily every 25km road and city and also sometimes significantly longer distances. My criteria 1. when it goes under 1500€ 2. no too high mileage and age (for the good feeling in the back of mind) 3. Diesel or petrol is actually no matter 4. in any case automatic (which should be as reliable as possible) 5. Size either larger compact or smaller station wagon. So no a6 combo with almost 5m length I came across the Ford Focus mk3 with 1.5l,120ps and automatic. But I can’t find out what this is for an automatic. I don’t think it should be a converter but a kind of dsg and thus potentially a bit more vulnerable. Is that correct? I’m happy about every tip. It would be nice, of course, if the car isn’t ugly like the night but that’s a matter of taste. Thank you very much. I’m happy about inspiration.