Hi, my friend has an auto focus and I've just purchased the auto fiesta which I think might have the same 4 speed transmission as the focus - definatly the same gear selector anyway lol.
Before buying people "warned" me it would be boring, and I can see why some may think that, but I think of it as more relaxed. I wouldn't go back to a manual now and neither would my friend. Its great around the city and pulls away like a little rocket (both mine and my mates focus). The ride is so smooth too - not just at gear changes, when accelerating and braking too - my passengers have commented on the smoothness compared to manuals (although thats obviously sometimes down to the driver).
The 4 speed doesn't give as good mpg as the manual versions but I managed to get 47mpg on a recent journey which isn't bad (mind the fiesta is a smaller car), still worth it for not having a clutch and gears in rush hour
Can't you take it for a test drive first to see what you think?
To summarise, I'm totally sold on autos and the people I know with automatic transmissions wouldn't go back now either. I can't wait for the new 6 speed Powershift on the new focus.
Keep us updated....