Automatic – Yes or No?

I’m looking for a Volvo. Either S60 or S80. Budget between 4000-600€, BJ 2006-2009 A former Volvo mechanic, who is now self-employed, however, advised me not to have an automatic on a vehicle of this age. He meant if there is something broken that can cost me a few thousand euros. I have already read that one should pay attention to certain things during the test drive during the circuit. However, since I have no idea of automatic gearboxes it will be f What is your opinion about this? Are there years of construction where the possible problems are more likely than others. Would you like your advice? Thank you.