Is there a software that will allow me to transfer video files (tv shows, movies) onto my digital camera?

I saw one that works only with the sony cybershot. I was wondering if there was one that would work with any digital camera.

I have a tv tuner card that already allows me to watch tv on my computer. But that's not my question. :)

There are many softwares which will do this - but first you need to have the hardware i.e. a Video Card which will bring the signal into your computer. After that you can try Super TV or Pinnacle Studio - I prefer Pinnacle since it allows you to make MPEG files (and edit them too) unlike Super-TV which is AVI format only and takes too much space.

AVS Video Editor is a powerful, yet easy-to-use tool, which provides advanced storyboard and timeline editing. Hundreds of effects, including video and text overlay, and chromakey effect, lots of filters and transitions will allow you to create impressive videos, slide-shows and more. Make your home video and save it in format that you need. For your additional convenience we redesigned burning manager in the following way: now DVD, VCD/SVCD and MPEG4 formats are separated from each other to avoid confusion when selecting an appropriate format. Now you can select, adjust or just learn the aspect ratio of your video. The new version provides you with more flexibilty in controlling your video processing. Choose 16:9 (widescreen format) or 4:3 (fullscreen format) aspect ratio according to your liking.An included full-featured Audio Editor, will let you to alter, trim and mix audio tracks for your video project. Moreover you can select and edit necessary audio tracks in AVI and DVD files. Friendly and understandable interface allows you to perform all the operations quick and easily. AVS Video Editor presents a perfect combination of attractive price and high-quality performance.