Base RSX 2005, 160k miles, running no problems at all. The key is regular maintenance here. RSX A/T tranny does the job pretty well and is defintely not the dumbest tranny I've ever driven. Besides that, mine shifts absolutely smooth and effortlessly (is this a word)?(well, remember we're still talking about a 10-15 year old cars though).
And well, I don't know if I have to say this, but check the A/T fluid dipstick for color (should be bright/light red) and the smell (shouldn't smell burnt or anything). My association was that it smells a little like cherry when it's fresh and new, but I guess it's just me

. And yes, Hondas and Acuras, as well as Kias require that you check the tranny fluid on a shut off engine (I recall this from working at Valvoline).
Also, make sure you have a chance to drive it cold since it is on the cold motor and transmission when you will be able to feel the jerks and rough shifting. Good luck!