Personally, I would select a camera that uses memory cards only.
A HDD is just one more mechanical piece of gear to fail - plus you have the potential problems of noise etc as mentioned previously. My previous camera was a tape based unit and they can have problems when you transfer to computer (it took me 5 capture attempts recently to get a clean capture of a recording - no idea why the first 4 suffered from jerkiness in the captured video), plus it takes real-time to get your video off i.e. a 1 hour recording will take 1 hour to capture.
A memory card based unit is more "electronic" i.e. fewer components to fail and video extract is literally as fast as your computer can copy the files!
These days you have far greater storage on a memory card based camera than a tape based unit i.e. I have just purchased a Panasonic HDC-TM200 (High Def) which comes with 16G built in - 2 hours recording time at full resolution. Plus add a 32GB card and I have an extra 4 hours.
The only issue is then what do you do when on holidays? tapes are cheap, memory cards are expensive. Well, most people have a laptop these days, just bring it on holiday with you and download every night. I picked up a 320GB 2.5" external HDD last week that runs off USB power - small, and compact and plenty of storage for video files! (especially in m2ts format).
And think - if you're taping a wedding or whatever you need to constantly check how much time is left on your tape - with 6+ hours of recording time available on memory cards I either don't have to check at all or maybe just once on the day! :-)
So stay clear of HD based cameras and go memory card is my personal recommendation.
Peter