Mazda's last rotary-powered car marked the end of an era. The Mazda RX-8 had style and great handling, but was marred by rust and reliability issues.