Visit this thread, which is still very much active: http://talk.qa.collegeconfidential.com/college-search-selection/1995005-time-for-another-thread-for-b-and-c-students-p1.html
You have a lot of options, and community college is not your only or “best” route (though it could be a great option, but only you would know this). There’s a myth, especially on this site, that colleges–good colleges–are unavailable to those with sub-3.0 GPAs. This is not at all true. Depending on your home state, the public flagship might even be in play.