My brother has a really nice Sony which uses a hard drive, but the video format is a bit of a bugger to work with for editing, etc.
I'd recommend getting the best Canon camcorder you can afford. Most of them record to SD and have internal storage, too. SD has become the standard, so it's best to stick to that.