On the subject of manumatics, I freaking loved my 330 (which I owned back in my driving every day days)–it really felt like a clutchless manual. The manumatic in a Highlander felt totally different, like I was just suggesting that it should shift sometime soon, and it started in 4th or something weird. So, I think they are rather hit and miss for people who want manuals but may have other reasons for getting an auto.
I have only read through the first page, so someone may have already posted this, but:
Lightly used, first-generation (pre-2009) Acura TSX. A low-mileage '07 or '08 should be in your price range, a perky 4-banger, you get 30+ highway if you want, the only options are “loaded” and “loaded with navigation,” and a very slick 6MT. I have an '06 and there isn’t a car under about $35K I’d rather have.
If you have to go new, there are plenty of cars in your price range that come with a stick, and aftermarket leather is only a couple grand. Before I got the car I have now I test-drove a Civic Si with leather. It can be done.