I have a BA in English Lit with no sciences whatsoever. And even in that my GPA is like a 2.5.
Do not do your pre-reqs at a community college.
An allopathic medical school (one that confers an MD) is going to be a long shot for you, and will only be possible if you are willing to go back to school for several years (three minimum, I'd reckon) and get essentially straight A's. Even doing that, would bring your GPA up to just over 3.1 or so, which would still make your odds remote.
Since you are coming from way behind, you want to do everything as right as possible. This means straight A's from a good program. Community colleges are fine, but you need every competitive edge you can get and a community college isn't viewed as competitive as is a four year.
Keep an open mind to osteopathic medical school (one that confers a DO). You have the same scope of practice as an MD and their acceptance criteria is much more flexible than MD schools. You will still need to spend a year or two buffing up your app, though.
Do med-schools look down on such an applicant?
Med schools will look down on the fact that you spent four years in college and came out with a 2.5. How much they will look down on this will largely depend on how long it's been. If you graduated last year, it's hard to use the excuse "I was young and foolish and know better now."
Med schools do not look down on folks who major in liberal arts, folks who do post-bacs or folks who decide on medicine later in life. If anything, they like seeing folks do this outside the norm.
It's going to come down to how bad you want to be a doctor. If you're willing to make some huge sacrifices and spend a good few years getting prereqs and beyond done and done well and are not fussy on the path you will take to become a physician... you have a shot. If you want to cut corners, rush the process, or are picky how you get there... not so good.
Best of luck with the process.