@Greg Carter have you looked at the Toyota Hybrids. They are excellent cars and self-charging. I had a Corolla company car and even with my heavy right foot was getting well over 60mpg.
On the subject of automatics, when Motability finally dispose of the cars they will always get a higher price for an automatic compared with a manual. I was lucky in that my BMW was only available as an automatic.