I always liked the suicide doors and the general looks of the RX-8 but as others have said, it burns a hell lot of fuel for a 1.3 (I remember it was sth like 12 lt/km which is equal to a 3 lt engine consumption). And then Wankels have their own reliability issues despite being greatly improved from the RX-7's days.. There's got to be a reason why Mazda is the only brand that keeps making those. But I guess that if you don't do many miles/year that should be fine, and you could always buy it, enjoy it and then sell it while it's still ok. Sometime around 2004-2005 there was a recall on these, you might want to know more about it.
I saw someone mention the S2000. What's the price for one there? Cause if it's in the same range with the RX-8 I'd definitely go for one. That's a hell of an engine! And it's a true thoroughbred..As a Honda, I bet it'll be reliable too.