Ok, went to the dealership and drove a PowerShift yesterday. Seems to drive fine and shifts smoothly, but it definitely does drop the revs as soon as it can so that the second you come to any incline it has to change a few gears. I have a feeling that a stick would be a lot more enjoyable with an engine this small.
The Focus rides and handles nicely, but I'm going from a Mazda 6 with a V6 and after driving the Focus I couldn't help but feel that I'm going to be downgrading. There are certain things on the Focus that scream "cheap", like the carpeting, the rear seats, the trunk liner, etc.
That said, the Focus gets much better mileage and will be lots lighter for towing behind my RV.