Automatic and leather are options, not standard fit, on most mid-size cars, so it's a matter of trawling through ads looking for those features. An automatic will obviously be more expensive to run than a manual because it uses more fuel. You'll obviously get better value in a Focus or cee'd than in a BMW 1-Series or an A3 or a Golf.