The upside is that the engine itself is tiny and mounted almost exactly in the middle of the car - under your feet. Rotary's get about 3x power for the same displacement as a reciprocating piston engine. They're great in airplanes.
I've spent a lot of time in an RX8 and it's a blast to drive if you're willing to deal with the cost and finicky nature of the beast. When the engine spools up and it just starts whirring... that's a beautiful thing.
But as other people have mentioned, they have some downsides, pretty much all due to their hard-to-seal and oddly-shaped "combustion chamber".
But nothing drives a following like an unusual design with inherent impracticalities (Cf. 45-degree V-twins, late-90's air-cooled Porsches, and Lisp ;).