I have an '06 RX8 with the six-speed manual. I wouldn't even consider the automatic because it's down on power (212hp for '06/197hp on '04 and '05 models- pathetic considering the manual has 238hp and redlines 1500rpm higher). Basic things to know before buying: rotaries consume more oil (check often) and gas than similar-sized piston engines. Standing-start acceleration is underwhelming but from 30mph and up, watch out! Rotaries need to be revved above 5000rpm to get the best performance. Run the car for at least 5mins to avoid flooding the engine. Handling on this car is phenomenal, a renowned Mazda trait. Car is not designed for snow/ice so don't bother driving in it.
Best handling car in this price range. mooth six-speed manual. Communicative steering. Nice two-tone leather seats. Can easily put hi-end sports cars, to shame in the twisties, but don't expect to win stop-light drag races. Fun, fun, fun!
Would like a 2-seater version like the gen3 RX7 was (I owned two), with either turbo-charging or a three rotor engine. It needs more torque (gen3 RX7's had 255hp/217lbs torque). Not a car for those who've never lifted a hood: Buy a Honda instead. Serious, competent drivers only :)