I recently purchased a Fiesta ST, which (along with the Focus ST) bucks this trend. The Fiesta is a cheap car, but the highest trim package, ST, is exclusively available as a manual and adds 70 HP. The Focus ST is the same, with an even bigger HP bump.
Hopefully somebody else decides to compete with Ford for the budget enthusiast market, and we get a bunch of fun manuals :)