Wrong, where do you guys get the idea that because the prof. is from a cc, they would look down on the letter. That is wrong. My friend applied last cycle and he spent his first two years at a cc and all his science lors were from the cc except one from his reaserch thesis instructor. Bottom line, he got interviews at all tx sckools and eventually got accepted to utsw. Man sdn are full of crappy advisors like the ones at my school
n=1
Many schools do not accept coursework (esp. prereqs) at a CC. What makes you think they're going to be any more accepting of the person who taught those courses?
Further, many CC instructors do not possess the terminal degree in their field (i.e., they only possess a bachelors or masters) -- this means they have little to compare to when it comes to the question, "Does this student have what it takes to succeed at this level of education?"
Finally, they likely have minimal experience writing LORs for graduate and professional programs, meaning your LOR is less likely to be strong.
In other words, while it may not directly harm the OP, it is less likely to help than would getting an LOR from a more respected university faculty member. This could indirectly hurt the OP, however, since others are getting LORs from the most recognized people available to them.
Since we are going w/ anecdotal evidence, however, here is a story that illustrates the importance of connections (it is from one of the top books on admissions in another ridiculously compretitive healthcare field):
The author was applying to a number of top schools as a post-bacc w/ a moderate GPA and test scores. He got an LOR from a jr faculty member with whom he had done research for several years. He was rejected from all of his schools, so, feeling dejected, he spoke w/ the chair of the dept for feedback.
After reviewing the author's application materials and hearing the story, the chair, a well-recognized and influential researcher, responded, "What the heck were you thinking having Dr. X, an Asst. Professor and junior faculty member, write your LOR?! They probably didn't even read it. Here, how would you like to go to [another extremely well-recognized institution]? I have a colleague there I've been working with and I think you'd be a good fit."
So within minutes, the chair writes up a simple emailing stating, "Dear Dr. Andrew Johnson, I have a student here by the name of Adam Smith. He wants to study Y and I believe he would make an excellent fit at your institution. If you have any questions, give me a call. Your Friend, Dr. David Brown."
Within a week, that applicant had an acceptance in hand (not even the standard interview). While this is a bit dramatic, it illustrates just what connections can do. To shun networking is to commit business suicide. Your LORs are, in a very real sense, utilizing others' networking. A CC prof simply does not typically have the network in academia that a seasoned professor possesses.