DVCAM and MiniDV are basically the same thing... they both record the same information just DVCAM uses more tape. Think of a Vhs tape EP and SP. Sp looks better but only records for 2 hours while EP records for 8, it looks a little worse.
HI8 is an analog consumer format, the quality is pretty bad.
BetaSP is an analog format, tailored more towards pro cameras with a resolution compareable to mini-DV.
HD cam has the highest avialable resolution becuase it's made for High Definition video. The cameras that use this format are very expensive.
For a film-like look, try looking for a mini-dv or DVCAM format. You should check out the 24p camera from panasonic. There is also a nice tutorial for creating a film like look within your NLE here:
http://www.digitalvideoediting.com/2003/12_dec/tutorials/filmlook_vegas4.htm
Try a google search for film-look. I'm sure you'll come up with many hits.