Evening all, hope you are all well?

So I'm looking at buying a B7 A4 Quattro in diesel but unsure which engine to go for and wether to go for manual or auto! Anyone have any help and advice, what to look out for, what common faults to expect etc etc, thanks.