Well there is this:
EcoModder Fleet list - EcoModder.com
You have to go scroll down pretty far before you get into serious numbers of automatic cars. There are a couple fairly high mpg priuses, but I can tell you from first hand experience it is much harder to drive them uber-efficiently than a stick. You have to outsmart a layer of automation to get there.
Or look at something like a 2014 yaris, users are reporting ~30% better efficiency with the stick:
Fuel Economy of 2014 Toyota Yaris