I think everyone thought you were talking about hooking it up to your truck.
Any HDD camcorder should work great for you if it's being taken from the stands. I use to have a JVC HDD cam, it was a beaut and had a crystal clear picture with 30x zoom. Now I just use my digital camera, most shoot in 1080p and have HDMI hook ups.