Do hard drive camcorders produce grainy film footage?

A friend of mine told me that with hard drive cameras, the image appears kind of grainy. Is that true? How about flash memory camcorders? Do they produce better video footage?
Update: Ok, but what about a standard def hard drive camcorder? I looked at the hd camcorders and they are too expensive for now. My absolute limit is $500.
4 answers 4