One of your requirements is going to have to give:
The only new Subaru with hood scoop and automatic is the Forester XT.
2010-current Legacy 3.6R -- No scoop, 5speed auto
2010-current Legacy 2.5i -- No scoop, CVT
2010-2012 Legacy GT -- Hood scoop, 6-speed manual transmission only
Older models with automatic:
2005-2009 Legacy GT -- Hood scoop, spoiler, 5-speed auto or manual.
2009-2011 Impreza WRX 2.5GT -- Hood scoop, spoiler, 4-speed auto. Avoid this one. The manual WRX has +30HP for the same price. Both the Legacy or WRX will get better mileage.