It'll work like a digicam if you mean not needing drivers. Windows Movie Maker should allow you to download the videos, I do beleive. However, it's not just drag and drop, or anything. You do have to basically find the video and let it play though onto your computer.
videohelp.com might be a good place to check out for other freeware apps...