I agree that the OP needs to get some solid academic work under her belt before applying, but I'm not sure why the downward trend from a CC to an Ivy would be surprising. I don't know, I'm not on an adcom, but my assessment of the situation is that you were a star stand-out at your CC and then at the Ivy you were surrounded by stars and so didn't stand out as much (i.e. weren't in the top quarter of the class so didn't get As anymore). Close to accurate?
Not sure if you know that any undergrad courses are averaged in with your other undergrad courses, so you can still take classes to bring that GPA up. I would probably not take them at a CC, as you've already demonstrated you can handle CC work; I would try to take them at a 4-year university.
I'd also ask yourself why your GPA was that low at Cornell/Brown. Were you trying as hard as you could but just couldn't keep up with the rest of the folks there? Or was it so different from the CC that you kind of had to learn how to learn at that level, and that takes time? Or were you going through a period of your life where you weren't concentrating so much on academics (it happens...)? Make sure this is addressed before you take more classes as anything less than an A/A- from this point on will hurt you.
SMPs are viable options for people whose GPA doesn't necessarily reflect their ability. If you're a capable student but were just momentarily stunned by the switch to the Ivy and then started to work your way back up (you mentioned you had an upward trend after the drop from your transfer), then this could be a way to show adcoms that you can handle med school.
Good luck. Keep us posted.