Now I also don't wanna give impression that i'm disparaging the LSX motors. GM did an amazing job designing a lightweight aluminum block motor from the ground up. it has also proven to be one of the most reliable motor series that GM has ever come up with and I have a friend that has put one in an FC and an FD, and i have zero issue with that.
Now the one rotary motor that I would say that got destroyed the most and propogated the reputation would have to be the the twin turbo version they had in the 3rd gen Rx-7, this was due to alot of contributing factors: owner ignorance being primary, and in my opinion alot of bad design decisions - which most FD owners are now familiar with and usually fix right off the bat when buying one. Mazda again has itself to blame for not educating it's american buyers. Turbos shorten the life of any motor, put a set of twins on an LSX and run it hard for ten years and I'm petty sure it'll be pretty much done by 100k miles.
Both motors have there positive and negative aspects.