Hi, goldy
I was also going thru this confusing state until I found out my requirements.
think what r ur objectives & then only better one can be defined.
There are several types under which camera is classified i.e depending upon their resolution, picture quality & storage etc...
Now take up ur question......camera with video tape or HDD,SD,SDHC compatible camera?
In terms of picture quality, as far as I know, its best in tapes but at the same time its quite cumbersome in storing & a bit expensive.
But in HDD, SD, SDHC, u have the comfort of shooting out without worrying about tapes & all. But at the same time, remember that the storage is limited....so u need to transfer to a PC or burn it DVD's for further shooting..