@arifk Hi. Well, in autocross not many cars are going to beat the Miatas! The C230 with MT was fun, but I never participated in SCCA or anything truly competitive. It was always MBCA autocross (we'd invite other local clubs with us like Alfa Romeo, BMW, Porsche, and others) so nobody was trying to win any points or trophies. But, people would ride in each other's cars and talk about how to make performance improvements and be better drivers. If you've already got the car, then you might as well use it and have fun. There are many other cars better suited for autocross. If you're an MB fan who wants a MT to shift, then you could find a second gen SLK350 with a MT.
2005 Mercedes-Benz SLK 350 for sale in Federal Way, WA - CARFAX Or, you could go newer and find a third gen SLK250 with an MT.
2013 Mercedes-Benz SLK 250 for sale in Sarasota, FL - CARFAX These would be better for autocross than a C Class. If you're an MB fan and don't want to row your own gears, get the newest SLK AMG you can afford. If MB is not important to you, then you could try many other cars. If you really want to compete, just look at the cars used by the top drivers in various SCCA autocross classes. I assume you can get all their event results online. And, if you venture out on an actual race track, your autocross car would be good enough to have fun and learn track driving.